MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel


Posted by Tom GReen on October 24, 2001 8:42 AM

Simple question but I don't know the answer.

How can I show negative time? I am trying to compile a flexi time spreadsheet and would like to show negative flexi by subtacting a 7 hour day from the time worked. Its OK if flexi is positive but not when negative.

Any ideas?


Posted by Juan Pablo on October 24, 2001 8:56 AM

If i remember correctly, if you set date system to 1904 (Tools, Options, Calculate, Book options, 1904 date system), you can have negative times.

Juan Pablo