Summing a "short time" field

  • Thread starter Thread starter Art
  • Start date Start date
A

Art

Hello,
I have a field in a table with times in hh:mm format.
I would like a query to add these times correctly.
EXAMPLE - 00.15, 1.05, 00.17, 00.50 would sum to 2:27 or
147 minutes. I need to get an average time for this field.

Thank you in advance for any help.
 
Art

If that field is an Access Date/Time field, you'll have problems. Access
uses Date/Time fields to store "point-in-time" data, not "duration" data.

If that field is of numeric datatype (and it needs to be to store duration),
you'll need to create parsing routines that takes the sum of 15 minutes, 1
hr & 5 minutes, 17 minutes and 50 minutes (147) and creates a text string of
"2:27". Try the mvps.org website for some leads.
 
Hi Jeff,
Thank you very much for your help. The table field
is date/time so it looks as if I may be in trouble.

art
 
Art

Not an insurmountable problem, but it will take more work -- again, check
mvps.org for some leads to how you might parse the pieces.
 
Back
Top