calculating time (HH:MM) totals within access 2002 reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a access database whose table consists of records with a
overtime data field containing hours and minutes (HH:MM). I would like to
create a total field at the end of the report that will give me the total
over time for all records.

How can I do that within the report? Is it easier to use just one field
like I have above or use two fields suchs as HH and MM then perform the
calculations?
 
What is the field name and data type? HH:MM is not a field type. It might be
a format but could be a text field.

A word of caution... it is rarely a good idea to store a duration of time in
a date/time field. Durations should be stored in numeric field with values
describing the number of hours or number of minutes.

Picture storing six days as 1/5/1900. These are actually the same value. Six
hours should be stored as 6.0 hrs and not 6:00 AM. 6 and 3/4 hours should be
stored as 6.75 hours or 405 minutes.
 
It is not stored in a numeric field as you recommended. I can change that.
But once that is done, how do I total up the hours and minutes?
specifically, how do I convert all the minutes in the minutes field to hours?
 
Back
Top