Please Help?????

[Chris Watson]

I want to add up time eg:Cell A1(13:00) + Cell A2(13:00) = Cell
A3(26:00), If I put in A3 the formula: =A1+A2 it works fine but if A1 &
A2 are the result of a formula from several other Cells eg:
B1(03:00)+B2(06:00)+B3(04:00) the result is 02:00 in Cell A3, I know
this is due to the 24 Hour clock but how can I get round it, I have
tried every time format and just get numbers. I have been on this
problem for hours now and its driving me mad, Please can somebody
help!!

 

[BadgerMK]

Chris try the following

=(A1/60*1440)+(A2/60*1440)

 

[Yngve]

Hi Cris

I find this in an other thred
select range a3 and

Click "Format" - Click "Cells" - Click "Number" Tab - Click "Custom" -
Select "[hh]:mm:ss" format

This sum houers

regards yngve