Displaying negative [h]:mm:ss

  • Thread starter Thread starter The Rook
  • Start date Start date
T

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
 
Tools > Options... > Calculation > and check the 1904 checkbox.

Then select the cell(s) and:

Format > Cells... > Number > Custom > hh:mm:ss
 
Yes, but be careful if you are copying data to and fro between 1900 and 1904
systems.
--
David Biddulph

Gary''s Student said:
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


The Rook said:
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
Click to expand...
Click to expand...
 
Back
Top