Displaying negative [h]:mm:ss

[The Rook]

I have a spreadsheet that is populated with the following:

Column A: authorised hours (formatted as [h]:mm:ss)
Column B: Actual Hours (formatted as [h]:mm:ss)
Column C: Variance (Column B - Column A, formatted aS [H]:mm:ss)

If column B is greater than column A then the result is correct, but if
column A is greater than column B the result is #########. I am wanting it
to result a negative figure. For example:

A B C
10:00:00 7:00:00 -3:00:00

Can this be achieved?

Thanks

 

[Gary''s Student]

Tools > Options... > Calculation > and check the 1904 checkbox.

Then select the cell(s) and:

Format > Cells... > Number > Custom > hh:mm:ss

 

[David Biddulph]

Yes, but be careful if you are copying data to and fro between 1900 and 1904
systems.
--
David Biddulph

Tools > Options... > Calculation > and check the 1904 checkbox.

Then select the cell(s) and:

Format > Cells... > Number > Custom > hh:mm:ss
--
Gary''s Student - gsnu200832

I have a spreadsheet that is populated with the following:

Column A: authorised hours (formatted as [h]:mm:ss)
Column B: Actual Hours (formatted as [h]:mm:ss)
Column C: Variance (Column B - Column A, formatted aS [H]:mm:ss)

If column B is greater than column A then the result is correct, but if
column A is greater than column B the result is #########. I am wanting
it
to result a negative figure. For example:

A B C
10:00:00 7:00:00 -3:00:00

Can this be achieved?

Thanks