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!
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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks