Sunday, July 15, 2018

yogi_Compute Average Waiting Time Hour By Hour From Check-In And Attended Times

Google Spreadsheet   Post  #2475

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jul-15-2018

question by: Kyle Sylverne!topic/docs/OUD4eaDlgoM;context-place=forum/docs
Formula to filter timestamp when averaging

I'm attempting to average wait times and want to filter the average based on the timestamp down to the hour. Below is a test spreadsheet of what I'm using. I'd like average column E (wait time duration) but filter the values based on column b's hours (so 6am, 7am, etc) I've attempted to try and play with the syntax and formulas and haven't been able to quite figure it out.