Adding Time Values Together

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am trying to add monthly working hours together eg 171.25 hours + 56.56
hours but cannot get Excel to do this. When I use HH:MM it changes the cell
to a time format but the answer is wrong despite the correct (I think) sum is
entered ie SUM(B3:CC3). All cells have been set to HH:MM format but again
when I enter the hours it changes the value. Can anyone help as I am going
mad trying to fix this!?
 
Hello
Use custom format :
[h]:mm
This will allow time calculations over 24 hours.

HTH
Cordially
Pascal
 
Pascal,

Thanks for your help and it does add up correctly now but when I enter the
hours in, the formula has the date in before ie when I put in 23.24 hours it
comes up as 22/01/1900 08:24:00 in the formula and 536:24 in the cell, how
do I put in the hours?

Regards

Angie (Who's sanity you are saving!)

papou said:
Hello
Use custom format :
[h]:mm
This will allow time calculations over 24 hours.

HTH
Cordially
Pascal

Angiewelly said:
Hi,

I am trying to add monthly working hours together eg 171.25 hours + 56.56
hours but cannot get Excel to do this. When I use HH:MM it changes the
cell
to a time format but the answer is wrong despite the correct (I think) sum
is
entered ie SUM(B3:CC3). All cells have been set to HH:MM format but again
when I enter the hours it changes the value. Can anyone help as I am going
mad trying to fix this!?
Click to expand...
Click to expand...
 
Back
Top