| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I show hours of more than 24 & negative hours?
Hi,
I am using Excel to calculate the hours I have worked, and compare with the standard working hours. Can someone help me to: a)Show hours of more than 24 as hh:mm rather than dd:hh:mm b)Show negative time where I have worked less than the standard hours. Thanks, Peter |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why cant you show negative numbers in parentheses? | Excel Discussion (Misc queries) | |||
| How to show negative time (e.g. -10 hours) | Excel Worksheet Functions | |||
| add column of minutes, show total in hours & minutes | Excel Worksheet Functions | |||
| Subtracting paid hours from unpaid hours | Excel Worksheet Functions | |||
| Have negative numbers show as zero | Excel Worksheet Functions | |||
Threaded Mode
