how do I calculate difference between two dates and times

[PatCN]

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!

 

[Gary''s Student]

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 Keramidas]

try formatting the cell like this

[h]:mm:ss

 

[Bob Phillips]

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

--

HTH

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