Hour and Minute Differences

[Supriya]

Cell A1=11/02/2004(dd/mm/yyyy)
A2=11/02/2004(dd/mm/yyyy)
B1=18:30(hh:mm)
B2=11:38(hh:mm)formats

Now C1=(A1+B1)-(A2+B2)
which shows the result as 6:52(hh:mm), which in fact should be
6:32(hh:mm)

What is the problem

 

[Niek Otten]

6:52 is correct. Why should it be 6:32?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Supriya]

Yes! U r Right!

Although i had typed 11:38, it was there on my mind as 11:58.

Thanks