I am trying to write a time card in a spreadsheet that compares time worked to standard hours. All works fine using the Time format until the result of a formula is negative i.e. when the actual hours worked are less than the standard hours. THe cell just returns "#"'s across its width.
Can anyone tell me how to display negative time values?
Thanks in advance