Timesheet hours format not adding

  • Thread starter Thread starter RustywitExl
  • Start date Start date
R

RustywitExl

I have a timesheet with a column for TOTAL APPROVED HOURS (a SUM of manually
entered approved hours formatted as Number) and TOTAL WORKED HOURS (a sum of
the hours Mon - Fri formatted as H:MM). Because of the formats, the hours
are adding, but giving different values.

Dont know how to explain it all b/c there are formuals involved. Any Excel
expert willing to look at my sheet (confidential info removed of course)
 
Hi,

In the cells that do the summing use the format

[h]:mm

and see if that gives the correct answer
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
If you have hours entered as numbers, rather than as times, divide them by
24 to get as Excel time, & format appropriately.
If you want a total, format as [h]:mm, as the square brackets allow the
hours displayed to go beyond 24 rather than wrapping round to zero again.
 
Back
Top