Software

Ask something
Discussion Locked

Excel Minus Time Calculations

0 helpful
8 replies

by laurie j

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

8 replies

by whatme?

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.

by laurie j

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.

by whatme?

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.

This discussion is closed to new replies.