Hour and Minute Differences

  • Thread starter Thread starter Supriya
  • Start date Start date
S

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
 
Please don't p[ost to more than one newsgroup.
See my answer in other newsgroup.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
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
 
Back
Top