General discussion

Locked

Excel Minus Time Calculations

By Laurie J ·
Does anybody know how to get Excel to show a negative minutes and seconds value? My work involves timing TV scripts - having done an initial estimate of a scene length, I enter it formatted as minutes and seconds. In the next column when the scene is recorded, I enter the actual time the scene lasted. In the third column is a formula to show the difference between the two, which when it's a negative figure appears unhelpfully as '#####'. Is there any way round this?

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel Minus Time Calculations

by DKlippert In reply to Excel Minus Time Calculat ...

=IF(B1>A1,B1-A1,TEXT(ABS(B1-A1),"-mm:ss"))

Collapse -

Excel Minus Time Calculations

by DKlippert In reply to Excel Minus Time Calculat ...

You could also change to 1904 standard times

For more date math see:

www.cpearson.com/excel/datearith.htm

Collapse -

Excel Minus Time Calculations

by Laurie J In reply to Excel Minus Time Calculat ...

Poster rated this answer

Collapse -

Excel Minus Time Calculations

by Whatme? In reply to Excel Minus Time Calculat ...

The answer from Mr. Kippert is right but if you see ####### in your cell as the answer, you have to widen the cell. It is too small for the answer.

Collapse -

Excel Minus Time Calculations

by Laurie J In reply to Excel Minus Time Calculat ...

Thuis was the first thing I tried and when I did the column just gets more #'s in it and the column get wider. The answer in Answer 1 above worked fine. Thank you for your time.

Collapse -

Excel Minus Time Calculations

by Whatme? In reply to Excel Minus Time Calculat ...

The answer from Mr. Kippert is right but if you see ####### in your cell as the answer, you have to increase the column width. It is too small for the answer.

Collapse -

Excel Minus Time Calculations

by Laurie J In reply to Excel Minus Time Calculat ...

Poster rated this answer

Collapse -

Excel Minus Time Calculations

by Laurie J In reply to Excel Minus Time Calculat ...

This question was closed by the author

Back to Software Forum
8 total posts (Page 1 of 1)  

Related Discussions

Related Forums