| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula for negative time durations
I am looking for a formula that will produce negative time durations...
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula for negative time durations
If you switch over to the 1904 date system (Tools | Options |
Calculation tab) then you can represent negative times. Be wary, though, that this can mess up dates within your workbook if they were entered in the default 1900 system. Hope this helps. Pete On Apr 16, 5:31*pm, DAZA wrote: I am looking for a formula that will produce negative time durations... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding up time durations? | Excel Discussion (Misc queries) | |||
| How do I show multiple time durations in a column bar chart? | Charts and Charting in Excel | |||
| How do I calculate time durations over numerous dates | Excel Worksheet Functions | |||
| What is the formula to display a negative time results? | Excel Worksheet Functions | |||
| Negative time should be allowed in Excel, eg time difference | Excel Discussion (Misc queries) | |||
Linear Mode
