| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculating negative time.
Is there a way to report negative "time". Example: I paid my employee
80:00:00 hours estimate (cell a1). He actually worked 72:00:00 hours (cell a2). He owes me 8:00:00 (cell a3) where (a3 = a2-a1). Problem is i get ###### instead of minus 8 hours or -8:00:00. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating growth with negative numbers | Excel Worksheet Functions | |||
| How do you enter a negative time number in Excel? | Excel Discussion (Misc queries) | |||
| Calculating negative time & creating scrol bars for fixed size txt box. | Excel Discussion (Misc queries) | |||
| Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
| negative time | Excel Discussion (Misc queries) | |||
Threaded Mode
