| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering Times | Excel Discussion (Misc queries) | |||
| How to use solver to schedule part time and full time workforce? | Excel Discussion (Misc queries) | |||
| adding in time formats | Excel Discussion (Misc queries) | |||
| Adding time to multiple cells using TIMECODE | Excel Discussion (Misc queries) | |||
| Time Sheets | Excel Discussion (Misc queries) | |||
Linear Mode
