Sunday, February 18, 2018

yogi_Compute Average Of Hours Worked By WeekDay From Table Of Date and Hours

Google Spreadsheet   Post  #2376

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

question by: KentuckyFriedIdiot
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/sZRKQEZVFeg;context-place=forum/docs
Averaging Hours Worked By Day Of Week
Hi guys,

I've been logging the days I work and the hours worked on each date. I'd like to get the averages for each day of the week. Here is my sheet 


Zeros are days not worked, I'm not sure if those would distort the average and if so, how to filter them out. Thanks so much!