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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Amending meeting cancels all future meetings 0
Adding rota 0
Averaging by half hour time intervals. 0
Aggregate the time data (mm/dd/yyyy:hh:mm:ss) into the 3 hours range 0
separating date and time 5
"Working times" for calendars incorrect 0
Return column values based on criteria (HLOOKUP & VLOOKUP?) 0
Wage Calculator Q 1

Top