Subtracting in Excel with Hour and Minutes

[gobi21]

Hi,

How can I subtract the below rows using the excel formulas to get the correct answers.

201601081026 201601081107 --- Producing wrong answer as 81
201601081040 201601081128 --- Producing wrong answer as 88

Please help me on this.

Thanks
Gobi

 

[Special-K99]

If the dates are the same then

=TIME(MID(B1,9,2),RIGHT(B1,2),0)-TIME(MID(A1,9,2),RIGHT(A1,2),0)
and format as Time with example 13:30:55

 

[MARZIOTULLIO]

	a​	b​	c​
1​	201601081026​	201601081107​	0:41:00​
2​	201601081040​	201601081128​	0:48:00​

<tbody>
</tbody>

HI

c1 =TEXT(B1,"0000-00-00 00\:00")+0-TEXT(A1,"0000-00-00 00\:00")+0 copy down

format c1:c2 as [h]:mm:ss

 

[gobi21]

Hi MARZIOTULLIO,

Thanks for your quick help. Your solution worked .

Cheers,

 

[MARZIOTULLIO]

Hi

You are welcome gobi21