Displaying negative [h]:mm:ss
 

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

Displaying negative [h]:mm:ss
 

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" wrote:

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

Displaying negative [h]:mm:ss
 

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

"Gary''s Student" wrote in message
...
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" wrote:

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