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.