Averaging Time

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

Guest

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
 
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
(e-mail address removed)
www.fmsinc.com/consulting
 
Back
Top