Summing a "short time" field

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.
 
J

Jeff Boyce

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.
 
G

Guest

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
 
J

Jeff Boyce

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.
 
Top