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
