Thursday, July 6, 2017

yogi_Compute Total Hours Worked From Daily Log Of From To Hours

Google Spreadsheet   Post  #2201
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-06-2017
question by CooperElle:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/ptItF96AX8k;context-place=forum/docs
How to calculate hours in google sheets

There is a specific formula (or function) I'm looking for in order to add all of my hours worked each week. I don't need one to calculate each day. For example it would look like:

((FORMULA))

1 Mon:   9-5 = 8hrs
2 Tues:  9-5 = 8hrs
3 Wed:  9-5= 8hrs
4 Thur:  9-5= 8hrs
5 Fri:     9-5= 8hrs
6 Sat:    OFF
7 Sun:   OFF

Total hours worked: ??