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!

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!

try formatting the cell like this

[h]:mm:ss

--


Gary


"PatCN" wrote in message
...
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!

Just subtract one from the other and format as [h]:mm

--

HTH

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


"PatCN" wrote in message
...
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!