You could use, in M10:M16
with custom format:![]()
=(K10-C10)-(F10-D10)-(J10-H10)
h "Hrs" mm "Min"
L10:
=M10*24, formatted as decimal
M18:
=SUM(M10:M16)
custom format:
[h] "Hrs" mm "Min Total for week"
You could use, in M10:M16
with custom format:![]()
=(K10-C10)-(F10-D10)-(J10-H10)
h "Hrs" mm "Min"
L10:
=M10*24, formatted as decimal
M18:
=SUM(M10:M16)
custom format:
[h] "Hrs" mm "Min Total for week"
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks