| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ADDING HOURS AND MINUTES
How does one add hours and minutes together to be able to get the total hours
and minutes added together: Eg: 12h24 + 14h15 + 10h10 must equal: 36h49 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ADDING HOURS AND MINUTES
Format your cells with Format/Cells/Number/Custom:
[hh]\hmm In article , Shane wrote: How does one add hours and minutes together to be able to get the total hours and minutes added together: Eg: 12h24 + 14h15 + 10h10 must equal: 36h49 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ADDING HOURS AND MINUTES
Put the data in as 12:24 (with a colon instead of the h). Add the cells up
and use [h]:mm as the format for the result. -- David Biddulph "Shane" wrote in message ... How does one add hours and minutes together to be able to get the total hours and minutes added together: Eg: 12h24 + 14h15 + 10h10 must equal: 36h49 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding up hours and minutes | Excel Discussion (Misc queries) | |||
| Adding minutes to hours/minutes | Excel Discussion (Misc queries) | |||
| Adding hours and minutes | Excel Worksheet Functions | |||
| Adding hours and minutes.. | Excel Discussion (Misc queries) | |||
| adding hours and minutes | New Users to Excel | |||
Linear Mode
