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?
|