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.


"RustywitExl" wrote:

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)

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.
--
David Biddulph

"RustywitExl" wrote in message
...
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)