Time Functions

  • Hello All,
    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


  • Hi Brian

    Use the 1904 date system. Select Tools|Options and then the Calculation tab. Check the "1904 date system"

    Now your able to display negative time values. :bsmile:


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!