Adding Time Values Together
 

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!?

Adding Time Values Together
 

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

HTH
Cordially
Pascal

"Angiewelly" a écrit dans le message
de news: ...
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!?

Adding Time Values Together
 

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" wrote:

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

HTH
Cordially
Pascal

"Angiewelly" a écrit dans le message
de news: ...
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!?