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