View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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