Subtotaling of hours
One way would be to multiply the sum by 24 and format the cell as a number.
Your result would be 16.25 (since 15 minutes is a quarter of an hour.)
--
Brevity is the soul of wit.
"Thomas" wrote:
Example:
A B C
TIMESHEET
In out Hours
8:00 17:15 8:15 [Hours is calculated, B - A, "In", "Out", formatted as
hh:mm)
9:00 17:00 8:00
Total xxxx
PROBLEM:
If I use SUM() to calculate xxxx the number is wrong.
What function can I use to come up with the correct total of 16:15 ?
Thanks a lot,
Thomas
|