SSRS format total minutes into total HH:MM:SS

Question

The current report expression presents the data in Days:Hours:Minutes:Seconds

=cstr(floor((sum(Fields!phoneInOutbound.Value) / 86400))) & " days " & 
cstr(floor(((sum(Fields!phoneInOutbound.Value) Mod 86400) / 3600))) & ":" & 
cstr(floor((((sum(Fields!phoneInOutbound.Value) Mod 86400) Mod 3600) / 60))) & ":" & 
cstr(floor(((sum(Fields!phoneInOutbound.Value) Mod 86400) Mod 3600) Mod 60))

I am trying to get it to show total Hours:Minutes:Seconds.

So far I have only managed to get minutes:seconds using the following expression;

=cstr(floor((sum(Fields!phoneInOutbound.Value) / 60))) & " : " & 
cstr(floor(((sum(Fields!phoneInOutbound.Value) Mod 60))))

Any idea how to reconfigure so I can get total hours:minutes:seconds?

Answer 1

Okay so your basically going to need to add the first statement (Where it originally gets days) plus the second statement (where it was originally hours). You can either change the first statement to get the days than days * 24 to get days back to hours THAN + 2nd statement. There's probably an easier way, not sure what your data set looks like or even what database your reading from. Just trying to get you thinking in the right direction.