Hi Carl
but then please explain HOW you come to this result looking at your
example data???
--
Regards
Frank Kabel
Frankfurt, Germany
carl wrote:
no. i meant 7 seconds.
"Bob Phillips" wrote:
I hope you mean 00:00:47!
=TIME(0,0,A2-A1)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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.
|