Calculating total hours

  • Thread starter Thread starter Dmackcwby
  • Start date Start date
D

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?
 
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")
 
Brian,

Thank you for your help. It worked perfectly.

Brian said:
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 said:
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?
Click to expand...
Click to expand...
 
Back
Top