ExcelBanter - How do I calculated total hours per week

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I calculated total hours per week (https://www.excelbanter.com/excel-worksheet-functions/41503-how-do-i-calculated-total-hours-per-week.html)

FrankF

How do I calculated total hours per week

I can calculate total hours per day using the formula =C4-B4+(C4<B4) but can
not get the week total when using a column total =(d2:d9) How do I get this
weekly total to work for payroll?

Aladin Akyurek

=SUM(D2:D9)

Custom format the formula cell as: [h]:mm.

FrankF wrote:
I can calculate total hours per day using the formula =C4-B4+(C4<B4) but can
not get the week total when using a column total =(d2:d9) How do I get this
weekly total to work for payroll?

All times are GMT +1. The time now is 07:08 PM.