| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I display negative time values in excell?
If you change the base date to 1904
(Tools|Options|calculation tab|check 1904 date system) you can see negative times. But be aware that you may mess up your dates (by 4 years and a day). And copying cells with dates between two workbooks with different base dates will cause this same trouble. tomashruska wrote: -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
| Negative Time | Excel Worksheet Functions | |||
| I seem unable to display negative values with brackets | Excel Discussion (Misc queries) | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
| negative time | Excel Discussion (Misc queries) | |||
Threaded Mode
