| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=hour formula
I have summed up the total time, e.g 34:40. Needed to split this into 2 cells
for hours and minutes. I used the =minute formula which worked fine but the =hour formula only showed 10hrs. How function can I use to show 34hrs? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting from 12-hour to 24-hour format | Excel Worksheet Functions | |||
| How do I set up a formula for parts (or units) per hour? | Excel Worksheet Functions | |||
| convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
| Formula for Hour Minute and Second | Excel Worksheet Functions | |||
| How can I round an hour to the nearest 1/4 hour? | Excel Worksheet Functions | |||
Threaded Mode
