| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to add hours and show actual hours not decimal numbers
I am trying to put together an employee work schedule, showing actual hours
for punch in and out times. How do I set it up to add actual hours not decimal hours. Example: 11 hours is 0.46, if I change it to military time it will show 11 hours for the day but the total for the week is still all of the decimals added up. This is probably simple to do but I am too new with this. Any help would be greatly appreciated, Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Decimal to Time | Excel Discussion (Misc queries) | |||
| Time Sheet to show hours owed | Excel Worksheet Functions | |||
| Show a time from one calculated cell as a decimal in another cell. | Excel Worksheet Functions | |||
| How to show negative time (e.g. -10 hours) | Excel Worksheet Functions | |||
| How can I show hours of more than 24 & negative hours? | Excel Worksheet Functions | |||
Threaded Mode
