Help on Simple calculation

  • Thread starter Thread starter Corinne
  • Start date Start date
C

Corinne

I have a worksheet that tracks hours and minutes worked.
The cells are formated as hh:mm. I can add up the hours
and minutes worked by each person over a month and I can
add up total time worked each day. What I also need is a
grand total for each month. That is the total of each day
worked. For some reason this just won't work, I have
tried adding the daily total, and each persons totals but
I just end up with a strange figure that bears no
relation to anything as far as I can see. Please help,
thank you.
 
Hi,

Format the grand total cell as [h]:mm.

Regards,

Jan Karel Pieterse
Excel TA/MVP
 
I just end up with a strange figure

What kind of strange figure? To sum >23:59 you'll need a custom format of
[h]:mm - that might be the problem.

HTH,
Andy
 
-----Original Message-----
I just end up with a strange figure
Click to expand...

What kind of strange figure? To sum >23:59 you'll need a custom format of
[h]:mm - that might be the problem.

HTH,
Andy


.
Click to expand...
Ok. The final sum would be over 24 hours, I manage to get
something like 20 hours 45 minutes. I will try the new
format when I get back to work on Monday. Thanks both for
your help. Sounds like it would work.
 
Back
Top