You are welcome. By the way, I notice that your posting is a response to
someone else posting, but it shows up in my newsreader as starting a new
message thread. I looked for the original message you responded to, but I
couldn't find it. Apparently, that message was (very?) old and is not in my
downloaded database of messages for this newsgroup. So, I'm guessing the
original poster is not going to see our messages.

Rick



"Jerome" wrote in message
...
Hi Rick,

Thanks for the valuable feedback its much appreciated ... I love this
forum
for all the valuable expertise it gives ... have a gr8 day

Jerome

"Rick Rothstein (MVP - VB)" wrote:

If you use these values

E2: 12/19/2007 4:30:00 PM

F2: 12/21/2007 4:17:00 AM

your formula returns 35 hrs: 46 mins which is 1 minute off. This much
smaller formula seems to return the correct values...

=TEXT(F2-E2,"[h] \h\r\s: m \m\i\n\s")

Rick


"Jerome" wrote in message
...
if the start date is in E2 and the end date in F2 then use the
following
formula. It displays the difference in hours and mins.

=INT((F2-E2)*24)&" hrs: "&INT((((F2-E2)*24)-(INT((F2-E2)*24)))*60)&"
mins"

best regards,

Jerome

"Jithu" wrote:

Hi,

Is is possible to find out the difference between two dates in Hours.

eg 4/4/2007 0.00AM and 5/4/2007 0.00AM

Difference is 24 hrs

Please sort this out...thanks in advance for the help.