| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
NEGATIVE HOURS (3)
Excell 2000
I read your comments ad I would like to precise my needs. I tried to format the cell like you told me to do < -h:mm and when I type 8:00 the result gives -8:00 but no further calculation can be made such as : Let say -8:00 in A1 and 2:00 in cell A2 and formula A1-A2 in A3 should give me -10:00 as a result in A3. Any others ideas ?? Thanks! André Lavoie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using if statement to subtract 24 hours from time still shows as a negative time from both responses under 24 hours | Excel Worksheet Functions | |||
| Negative hours [h]:mm:ss | Excel Discussion (Misc queries) | |||
| I want to get negative hours if subtraction of hours is negative | Excel Worksheet Functions | |||
| How can I show hours of more than 24 & negative hours? | Excel Worksheet Functions | |||
| NEGATIVE HOURS (2) | Excel Programming | |||
Threaded Mode
