Calculating total hours

[Dmackcwby]

I have a report were I add up the total number of seconds and then report
that in hours:minutes:seconds. The control source reads
=Sum([ETime])/(60*60*24), the format reads h:nn:ss. It displays in the
format I want but I need it to show total hours such as 32:25:00 for 32 hours
25 minutes and 0 seconds. It gets to 23 hours then kicks over to days. How
do I set the format to show hours over 24?

 

[Brian]

Convert the days to hours, then tack on the minutes & seconds, like this:

=Int(Sum([ETime])/ 60 / 60) & ":" & Format(Sum([ETime])/ 24 / 60 / 60,
"nn:ss")

 

[Dmackcwby]

Brian,

Thank you for your help. It worked perfectly.

Convert the days to hours, then tack on the minutes & seconds, like this:

=Int(Sum([ETime])/ 60 / 60) & ":" & Format(Sum([ETime])/ 24 / 60 / 60,
"nn:ss")

I have a report were I add up the total number of seconds and then report
that in hours:minutes:seconds. The control source reads
=Sum([ETime])/(60*60*24), the format reads h:nn:ss. It displays in the
format I want but I need it to show total hours such as 32:25:00 for 32 hours
25 minutes and 0 seconds. It gets to 23 hours then kicks over to days. How
do I set the format to show hours over 24?