Calculating difference between swim times and swim standards

[Rodenback]

Hi,

I'm trying to setup a sheet to calculate the difference between the swim time of my swimmers and the standards they need to reach to attend bigger competitions. I'm using the [mm]:ss.00 formatting in the swim times fields. With a simple formula (=C2-D2) it works well when the standard is slower than the time of the swimmer. When the standard is faster than the swim time and the difference is negative, Excel returns a series of ######## instead of the negative time difference. What can I do to get the negative time difference? Thanks!

A	B	C	D	E
1	Event	Pool Length	Best Swim Time	Standard	Difference
2	50m Free	25m	0:33.50	0:30.20	00:03.30​
3	100m Free	25m	1:15.99	01:16.53	##########​

 

[Rodenback]

Just notice the letter for the columns moved in the cut & paste. They should all be one to the left.