Timesheet hours format not adding

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)
 
M

Mike H

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.
 
D

David Biddulph

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top