Re: $$Excel-Macros$$ Calculate Difference between two dates

2011-01-27 Thread Paul Schreiner
excel-macros@googlegroups.com Sent: Thu, January 27, 2011 12:18:23 AM Subject: $$Excel-Macros$$ Calculate Difference between two dates Hi, How do we calculate the difference between two dates in Hours. Dates are like mm/dd/ format only. -- Thanks and Regards,J

Re: $$Excel-Macros$$ Calculate Difference between two dates

2011-01-26 Thread ashish koul
OR USE =INT((A1-B1)*24) On Thu, Jan 27, 2011 at 11:54 AM, ashish koul wrote: > > > =TEXT(A1-B1,"[HH]:MM") > > On Thu, Jan 27, 2011 at 10:48 AM, Jitendra Verma < > jitendra.kumarve...@gmail.com> wrote: > >> Hi, >> >> How do we calculate the difference between two dates in Hours. >> Dates are l

Re: $$Excel-Macros$$ Calculate Difference between two dates

2011-01-26 Thread ashish koul
=TEXT(A1-B1,"[HH]:MM") On Thu, Jan 27, 2011 at 10:48 AM, Jitendra Verma < jitendra.kumarve...@gmail.com> wrote: > Hi, > > How do we calculate the difference between two dates in Hours. > Dates are like mm/dd/ format only. > > -- > *Thanks and Regards,* > Jitendra Kr. Verma| Sr. Software Engin

$$Excel-Macros$$ Calculate Difference between two dates

2011-01-26 Thread Jitendra Verma
Hi, How do we calculate the difference between two dates in Hours. Dates are like mm/dd/ format only. -- *Thanks and Regards,* Jitendra Kr. Verma| Sr. Software Engineer Mob: +91.9700695633 -- -- Some important