View Single Post
  #1   Report Post  
Curtopia Curtopia is offline
Junior Member
 
Posts: 2
Default Comparing Stop Watch Times

I am trying to compare stop watch times against a control time which is a touch pad time.

I populated the touch pad times along with the stop watch times and formatted the times using the custom format mm:ss.00

I then created a simple formula that subtracts the stop watch time from the touch pad time to determine the delta.

The problem: If the delta is either zero (same times) or positive, it works. If the delta is negative, it does not work, just shows up as #####.

Example:
1:05.00 1:04.00 =(A-B) 00:01.00 works
1:05.00 1:05.00 =(A-B) 00:00.00 works
1:05:00 1:06.00 =(A-B) ###### Does not work regardless of the column width

Any thoughts?