Displaying negative hh: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 to hh:mm(ss)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying negative [h]:mm:ss 2
Adding time after calculation 9
To Display Negative Dates 2
How to customize =Now() 11
New time format 5
Getting MM-DD HH:MM out of Julian date 4
Calculate the amount of time over a permitted amount (12 hours) 7
MROUND time 2

Back
Top