hh:nn:ss greater than 24 hours ????

[Moxioron]

Hello.

I have a report with the following formula at the bottom:

=Format(Sum([SumOfTime])/86400,"hh:nn:ss")

Works awesome except with the result is greater than 24 hours...then it resets back to 0.... For example if the result is supposed to be 27:21:45 .... I get 03:21:45.

I could use dd:hh:nn:ss, but I would rather have the total hours.

Where am I going wrong?

Thanks for your help.

 

[Moxioron]

Found it!

=Format(Int(Sum([SumOfTime])/3600),"00") & ":" & Format(Int((Sum([SumOfTime])-(Int(Sum([SumOfTime])/3600)*3600))/60),"00") & ":" & Format(((Sum([SumOfTime]) Mod 60)),"00")

 

[shg]

Another way:

=Text(NumberOfSeconds/86400, "[h]:mm:ss")