In A1 1/6/2005 16:15
In B1 1/8/2005 23:10
In C1 enter =B1-A1
Format C1 as Time 37:30:55 and you will see:


54:55:00

--
Gary''s Student


"PatCN" wrote:

Trying to calculate load time of vessels, i.e., vessel arrives 01/06/05 16:15
and finished 01/08/05 23:10.......what is the total time. When the date/time
to finsih covers several days, I can't come up with the actual HH:MM to load
vessel. HELP!