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

first of all, it needs to be a TRUE Excel "DATE", not just a string of characters that LOOK like a date. To determine this, try changing the format to "General". If it is a date, it will convert to a number. That's because to Excel, a "date" is really the number of days since 1/1/1900. So today,

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

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

=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