Hi
Try this:
=(C2+D2)-(A2+B2)
and format the result as [hh]

--
Andy.


"Akhilesh Dalia" wrote in message
...
I have few thousand rows, which contain arrival date, arrival time,
received
date & arrival time. I want to get difference in hours, what is the
difference between arrival and received.

Few examples
A B C D
01/Jan/2005 12:14:29 PM 02/Jan/2005 9:30:00 AM

based on above data in E column I want difference between date & time in
total hour.

Thanks for spent your time on this question.

Regards

Akhilesh Dalia
akhileshdalia<athotmail<dotcom