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


    Brian

  • 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:


    HTH
    /Fredrik

Participate now!

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