| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to get negative hours if subtraction of hours is negative
A B C D E 1 In Time Out time Actual hours Working hours 2 9:00 17:00 8:00 8:45 =C2-D2 In the E2 cell i am getting only ####,here i want to get the negative hours |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculation with hours and minutes - input of negative values | Excel Discussion (Misc queries) | |||
| how do i show negative time in hours minutes | Excel Worksheet Functions | |||
| Negative Working Hours | 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
