0

Is there any way to make Excel show a negative time span? If I subtract two time values (say, when subtracting the actual amount of time spent on something from the amount of time planned for it) and the result is negative, Excel just fills the result cell with hashes to notify me that the result cannot be displayed as a time value. Even OpenOffice.org Calc and Google Spreadsheets can display negative time values.

Is there a way to work around that issue by using conditional formatting? I really don't want to create some workaround by calculating the hours and minutes myself or anything like that.

Toto
  • 19,304
gitpyxl
  • 1

2 Answers2

0

Navigate to:

  • Preferences
  • Formulars and Lists
  • Calculation

Check the checkbox: Use 1904 date system.

Excel will now display negative times (times starting with -).

DavidT
  • 1,242
0

If you are using Office on Windows, locate to: File > Options > Advanced, under "When calculating this workbook", tick the box of "Use 1904 date system".

Emily
  • 4,035