Showing negative 'Times' in cells.

  • Thread starter Thread starter Chives
  • Start date Start date
C

Chives

Please help!

How can I display time when it goes negative in the cells?

My current Format setting is as follows:
[Blue][h]:mm;[Red]-[h]:mm

Any help would be most appreciated.

Thanks!
 
The (WinXL) default 1900 date system can't show negative time formats.
One way is to use the 1904 system:

Tools/Options/Calculation, check the 1904 Date system checkbox

Then use your custom format
 
Back
Top