ExcelBanter - Adding time

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Adding time (https://www.excelbanter.com/new-users-excel/56849-adding-time.html)

trucker

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

Roger Govier

Adding time

Hi
In the cell with the formula, FormatCellsNumberCustom [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

All times are GMT +1. The time now is 01:12 AM.