| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative and Positive Time
I have a cell in whic the formula may return a positive time or negative time
depending on the hours worked. I can format the cell to display a positive time or a negative time but not to switch between the 2. I have tried formatting the cell to h:mm;(h:mm) and using the 1904 date system but neither work HELP!!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add sequences of positive then negative numbers | Excel Discussion (Misc queries) | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| Summing negative time | Excel Discussion (Misc queries) | |||
| Negative Time Values | Excel Discussion (Misc queries) | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
Threaded Mode
