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

"Angiewelly" <(E-Mail Removed)> a écrit dans le message
de news: 58B3FE8E-7496-4CD9-BF2A-(E-Mail Removed)...
> 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!?

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" <(E-Mail Removed)> a écrit dans le message
> de news: 58B3FE8E-7496-4CD9-BF2A-(E-Mail Removed)...
> > 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!?
>
>
>