Time add of 24hrs+

Hi,

I have the attached spreadsheet.

All i'm trying to do is add time which is more than 24 hours to a date/time field and then give me a result.

i.e. D2+C2 should equal 15/05/2013 12:00:00 AM for example (I believe)

The formula works if the time is within 24 hours which you will see in row 3.

Any help would be great.

I'm in Australia so the date/time format of dd/mm/yyyy hh:mm:ss is perfect for me.

Cheers

hi PD. i believe your egs are for row 3 & 4, and not 2 & 3? try this in E2:
=IF(ISNUMBER(C2),D2+C2/24,"")

If you review the TIME function syntax, you will see that it cannot return values greater or equal to one day or 0.999999999...

You'll have to go the way Beni showed

Thanks Beni. That worked perfectly.

Thanks Pepe... that makes sense i'll know for next time.

Cheers guys.