Forum Discussion
Write negative hours in Excel cell
Hi, when I try to insert a negative time in an Excel cell, for example -10:12, Excel interprets the input as the selection of lines 10-12, and not as a time. Can you help me solve this problem?
Excel cannot work with negative times unless you change the file's date system to 1904. But that has quite some negative implications. Better to just enter positive times and negative times in a separate column so you can act accordingly by adding values in the pos column and subtracting in the neg column.
JKPieterse .., what are he negative implications of changing the file data system to 1904?
- If you copy information from a workbook with that box checked to a workbook without the box checked, any date values will be off by almost four years!!!!!