Hi,
See CPearson web has the solution you are looking for with examples

http://www.cpearson.com/excel/DateTimeWS.htm

if this helps please click yes, thanks

"Brownie_D75" wrote:

I need a formula to shows hours between dates.

Example:
Truck arrived @ 22:00. It arrived on 7/28/09. As of 7/30/09 @ 05:30, how
many hours has that truck been here?