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]

Please don't p[ost to more than one newsgroup.
See my answer in other newsgroup.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Robert McCurdy]

Hi Supriya.

Ok - A1 - A2 would be zero as the dates are the same
B1 - B2 is 18:30 - 11:38 which is 6:52 and
this is the answer you got.

Why do you think it should be 6:32 ?


Regards Robert