Summing Issue on Time entries

  • Thread starter Thread starter aMack
  • Start date Start date
A

aMack

--
A MACKENZIE, CMA, MBAI need the users to enter time lost such as 1 hr 32 min.

I than need to sum the total lost time over a period of time: 1:32 + 5:30 +
8:00 = 15:02.

What data field type should I use?

How do I get the sum to display as 15:02 on a report? Using date/time is not
working.

Thanks
 
aMack said:
need the users to enter time lost such as 1 hr 32 min.

I than need to sum the total lost time over a period of time: 1:32 + 5:30 +
8:00 = 15:02.

What data field type should I use?

How do I get the sum to display as 15:02 on a report? Using date/time is not
working.
Click to expand...


You can use a Date/Time field in the table so users can
enter 1:32.

However, if a sum of those time value exceeds 24 hours, you
can not use a time format to display something like 25:02.
Instead your report can use a text box expression such as:
=Int(24 * timelost) & Format(timelost, "\:nn")
 
Back
Top