Averaging Time

[DEI]

I am working with a time field in a table and would like to confirm the way
in which I am calculating average time of day. The time field records the
time of patient discharge.

Can I obtain the average time of discharge for a given interval (day, week,
etc.) by: Format(Avg([time]),"ttttt")?

Similarly, can I obtain the standard deviation in hours/minutes/seconds by:
Format(StDev([time],"hh:mm:ss")?

Thanks in advance.

DEI

 

[[MVP] S.Clark]

Select ID, format(Average([MyTime]),"tttt" ) GROUP BY ID

Standard Deviation shouldn't be much different


--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
[email protected]
www.fmsinc.com/consulting