Just multiply the result by 24

=(A7-A6)*24

if you only want hours, no minutes fraction use

=INT((A7-A6)*24)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Karan" wrote in message
...
Hi all,

I have to different Date time values. That are Received Date time value
and
Informed Date time Value. Both the values are customised in the format as
follows:
dd.mm.yyyy hh:mm:ss AM/PM

Now, i want to find out the difference in hours between two dates in
excel.
I know how to do it in Access, but not getting through in excel the same
formula.

For example Received date is 19.04.2005 11:30:00 AM
and Informed Date is 21.04.2005 12:30:00 PM the result should be 49, that
is
in hours.

Any help will be highly appriciated.

Thanks in advance

Karan.