| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Times in Excel 2000
How can I represent negative times in Excel 2000
|
|
#2
|
|||
|
|||
|
You can change to the 1904 date system under Tools
Options, but do so cautiously. To learn more, see: http://www.cpearson.com/excel/datetime.htm#AddingTimes The method I prefer is to subtract the 2 times (you can still use negative time values in calculations, you just can't see the result), hide the cell, then use another cell to display the negative time as text. See: http://tinyurl.com/5l2bx HTH Jason Atlanta, GA -----Original Message----- How can I represent negative times in Excel 2000 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
| why templates do not load into excel 2000? | Excel Discussion (Misc queries) | |||
| How do I duplicate a sheet 20 times in an excel spreadsheet | Excel Worksheet Functions | |||
| Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions | |||
Linear Mode
