=TIME(INT(A2/10000),INT(MOD(A2,10000)/100),MOD(A2,100))-TIME(INT(A1/10000),INT(MOD(A1,10000)/100),MOD(A1,100))
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"carl" wrote in message
...
My time data looks like this:
COLA COLB
93357
93404
Is there a formula that i can use in B2 that will tell me the difference
between the 2 times (00:00:7 hours:min:seconds) ?
Thank you in advance.
|