How do I calculated total hours per week

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

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

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?

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