Adding time

[Guest]

I want to add time,like a sum.

12:00+12:00+12:00=36:00?

I keep getting a basic time like 12:00. Could you please supply a formula.

Thank you

 

[Roger Govier]

Hi
In the cell with the formula, Format>Cells>Number>Custom [h]:mm
Putting the [ ] brackets around h allows it to sum past 24 hours.

Regards

Roger Govier