Forum Discussion
Seeking Code/VBA for Average WaitTime Per Hour
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:
If a specific hour doesn't appear this means no 'Ticket' was issued during the hourly period, yes?
- What would the formula look like if I want to represent the sum of tickets issued per hour for each of the hours represented?
What would the formula look like if I want to represent the sum of tickets issued per hour for each of the hours represented?
Try this
=IFERROR(COUNT(FILTER(Sheet1!$B$2:$B$243,HOUR(Sheet1!$C$2:$C$243)='Summary Data'!B7)),"")
mathetes
Is there a way to make the output 'vertical'. Seems unnecessarily complicated but it's what is being requested, if possible. In my ignorance it looks like a different formula would be required in each field.Date 6 7 8 9 10 11 6/3/2019 0:21:17 0:24:46 0:22:29 0:26:11 0:30:47 0:29:52 No. Trips 5 73 62 77 85 77
