Hi Carl
If your data always has the latest time in the second cell, then with early
time in A1 and late time in A2
=RIGHT(A2,2)-RIGHT(A1,2)+60
works for me
--
Regards
Roger Govier
"carl" wrote in message
...
My time data comes in like so:
93555
93600
Difference of 5 seconds
103058
103101
Difference of 3 seconds
Is there a way to convert these trimes so that when they are subtracted, I
can get the correct difference ?
Thank you in advance.
|