Conv time so I can get an Average

[Leon]

I need to get the ave of time expl: 10:00, 1:00 9:00
Ave is 6.667 how can I do this in Access
All help will be greatly apreciated

[John Nurick]

Hi Leon,

If the times are stored in an Access date/time field - I'll
call it "TimeField" - beneath the surface they are just numbers
in the range 0 (midnight) to nearly 1 (23:59:59.9999 or
thereabouts).

To get the average as decimal hours, use a calculated field in
a Totals query, like this
AvgTime: Avg(CDbl([TimeField])*24)

Or to get it as a string showing hours, minutes and seconds use
something like this:
AvgTime: Format([TimeField], "hh:nn:ss")

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.