Calculate Average Waiting Time

[shoggy]

Hi,

I need to calculate an average waiting time for patients waiting to be seen in an A&E dept between two dates.

I have calculated the total waiting time for each patient with the following formula

Total Waiting Time: Format([Time Arrived]-1-[Time Left Department],"Short Time").

Any help much Appreciated

 

[namliam]

Just take away the format and make a group by query...

 

[ColinEssex]

How do you plan to calculate where the A&E wait is going over midnight?

Col

 

[shoggy]

I've got it work across midnight with with the following

Total Waiting Time: Format([Time Arrived]-1-[Time Left Department],"Short Time")

 

[ColinEssex]

Yes thats good. I never tested it and know the midnight thing can catch people out sometimes.

Col

 

[shoggy]

I still can't get the average time to work in my query. Could anyone give an example please??

 

[namliam]

AverageWait: Avg([Time Arrived]-1-[Time Left Department])

 

[shoggy]

I keep getting a negative figure back when I run this

 

[namliam]

You said that that was working???

Perhaps if you remove the -1??

 

[shoggy]

I haven't said that it was working, I said that I can calculate the total waiting time for each person, but not the average waiting time for everyone.

 

[namliam]

Can you post a sample DB?