Forum Discussion
Seeking Code/VBA for Average WaitTime Per Hour
Seeking assistance creating a text box that has the output of - Average 'Wait Time' in in a given hour.
There are blanks in the 'OutTime' column that need to be accounted for.
Is this possible using the sample test data provided, and how?
A spreadsheet is attached that computes the average wait time for each hour of a day you select. This relies entirely on functions that are only available in newer versions of Excel, so if it doesn't work for you that would be the reason. Blank fields are not included in the calculation of averages, so if that's what you meant by "blanks in the 'OutTime' column that need to be accounted for" then there's no reason to worry. They are not reducing the averages.
It looks like this:
A spreadsheet is attached that computes the average wait time for each hour of a day you select. This relies entirely on functions that are only available in newer versions of Excel, so if it doesn't work for you that would be the reason. Blank fields are not included in the calculation of averages, so if that's what you meant by "blanks in the 'OutTime' column that need to be accounted for" then there's no reason to worry. They are not reducing the averages.
It looks like this:
- The column with the '13, 14, 15' represents the hour of the day, such as 13 is 13:00 (1:00 pm), 14:00 (2:00 pm), etc., yes?
If a specific hour doesn't appear this means no 'Ticket' was issued during the hourly period, yes?- It was a limited database, but yes, that's what it would mean.
