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: ??