Google Spreadsheet Post #2475
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Jul-15-2018
question by: Kyle Sylverne
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/OUD4eaDlgoM;context-place=forum/docs
Formula to filter timestamp when averaging
Hello,
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.
Thanks
https://docs.google.com/
No comments:
Post a Comment