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]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

a​

[/TD]
[TD]

b​

[/TD]
[TD]

c​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]

201601081026​

[/TD]
[TD]

201601081107​

[/TD]
[TD]

0:41:00​

[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

201601081040​

[/TD]
[TD]

201601081128​

[/TD]
[TD]

0:48:00​

[/TD]
[/TR]
</tbody>[/TABLE]


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