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
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
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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks