# how do I calculate difference between two dates and times

1. ## how do I calculate difference between two dates and times

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!

2. ## RE: how do I calculate difference between two dates and times

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!

3. ## Re: how do I calculate difference between two dates and times

try formatting the cell like this

[h]:mm:ss

--

Gary

"PatCN" <PatCN@discussions.microsoft.com> wrote in message
news:1AC71023-1CA4-4376-BC6E-07F7B91C9D8A@microsoft.com...
> 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
> vessel. HELP!

4. ## Re: how do I calculate difference between two dates and times

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

--

HTH

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

"PatCN" <PatCN@discussions.microsoft.com> wrote in message
news:1AC71023-1CA4-4376-BC6E-07F7B91C9D8A@microsoft.com...
> 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

> vessel. HELP!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1