Carl

one way:

=(LEFT(A4,2)*3600+MID(A4,3,2)*60+RIGHT(A4,2))-(LEFT(A3,2)*3600+MID(A3,3,2)*60+RIGHT(A3,2))

Regards

Trevor


"carl" wrote in message
...
My time data comes in as so:

103058
103101

Is there a formula that can tell me the difference ( 3seconds) ??

Thank You in advance.