Time / Formula to look at time difference
 

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.

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.

=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.

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.

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.

Hi
sorry, forget my post. Use Niek's answer

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