| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding hours and minutes
I'm trying to create an Overtime sheet for work hours. However, If I work 16
hours 1 day and 9 the next, this totals to 01:00 instead of 25:00. I'm losing money... please help me. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding hours and minutes
Format Custom as [h]:mm
-- Kind regards, Niek Otten "leo" wrote in message ... I'm trying to create an Overtime sheet for work hours. However, If I work 16 hours 1 day and 9 the next, this totals to 01:00 instead of 25:00. I'm losing money... please help me. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding hours and minutes
Use a custom number format of
[hh]:mm The [] characters tell Excel not to "roll over" time at 24 hours. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "leo" wrote in message ... I'm trying to create an Overtime sheet for work hours. However, If I work 16 hours 1 day and 9 the next, this totals to 01:00 instead of 25:00. I'm losing money... please help me. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding up hours and minutes | Excel Discussion (Misc queries) | |||
| adding hours and minutes | Excel Discussion (Misc queries) | |||
| Adding minutes to hours/minutes | Excel Discussion (Misc queries) | |||
| adding hours and minutes | New Users to Excel | |||
| Adding hours and minutes together | Excel Programming | |||
Hybrid Mode
