Displaying negative hh:mm:ss

T

The Rook

I have a spreadsheet that is populated with the following:

Column A = authorised hours (formatted to hh:mm(ss)
 
T

The Rook

The Rook said:
I have a spreadsheet that is populated with the following:

Column A = authorised hours (formatted to [h]:mm:ss)
Click to expand...
Column B = Actual Hours ( formatted to [h]:mm:ss)
Column C = column b - column A

Example

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

Can this be acheived?

Thanks
 
Top