+ Reply to Thread
Results 1 to 4 of 4

how do I calculate difference between two dates and times

  1. #1
    PatCN
    Guest

    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. #2
    Gary''s Student
    Guest

    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. #3
    Gary Keramidas
    Guest

    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
    > load
    > vessel. HELP!




  4. #4
    Bob Phillips
    Guest

    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

    load
    > vessel. HELP!




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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