Adding time

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

0
trucker (1)
11/22/2005 10:08:01 PM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
702 Views

Similar Articles

[PageSpeed] 57

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


trucker wrote:
> 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
> 
0
roger1272 (620)
11/22/2005 10:18:43 PM
Reply:

Similar Artilces: