Adding time

T

trucker

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
 
R

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
 
Top