Closed Thread
Results 1 to 8 of 8

Calculating time difference

  1. #1
    Forum Contributor
    Join Date
    07-06-2006
    Posts
    108

    Calculating time difference

    Hi everyone,

    Instead of calculating a time difference manually I want to have a formula do it for me. What I want to achieve goes as followed:

    08/06/2006 04:33

    12/06/2006 01:05

    Time difference is 92:32 [hh:mm]


    Another example:

    09/06/2006 12:42

    12/06/2006 11:35

    Time difference is 70:53 [hh:mm]


    So instead of getting 92:32 and 70:53 by calculating it myself I would like to have a formula do it for me. Otherwise I'll have to invest a lot of time to get the information I need.

    Thx in advance

    Regards



    Tom
    Last edited by TomBP; 09-29-2006 at 05:14 AM.

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097

    Thumbs up

    Quote Originally Posted by TomBP
    Hi everyone,

    Instead of calculating a time difference manually I want to have a formula do it for me. What I want to achieve goes as followed:

    08/06/2006 04:33

    12/06/2006 01:05

    Time difference is 92:32 [hh:mm]


    Another example:

    09/06/2006 12:42

    12/06/2006 11:35

    Time difference is 70:53 [hh:mm]


    So instead of getting 92:32 and 70:53 by calculating it myself I would like to have a formula do it for me. Otherwise I'll have to invest a lot of time to get the information I need.

    Thx in advance

    Regards



    Tom
    Hi Tom BP,

    If start date/time in A1 and end date/time in A2, then in A3

    =A2-A1, then custom format to [hh]:00

    oldchippy

  3. #3
    Forum Contributor
    Join Date
    07-06-2006
    Posts
    108
    Thx oldchippy. Works like a charm now. I changed [hh]:00 to [h]:mm tho.

  4. #4
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Quote Originally Posted by TomBP
    Thx oldchippy. Works like a charm now. I changed [hh]:00 to [h]:mm tho.
    Glad to be of help, thanks for the feedback

  5. #5
    Forum Contributor
    Join Date
    07-06-2006
    Posts
    108
    No problem oldchippy

    It isn't over yet tho. I was stupid enough to make a different column for date and time. It looks like this:

    A1 ------- -- A2
    07/06/2006 10.00

    Now instead of changing the format of A1 and adding 10.00 manually is there a way I can merge those two cells so it shows 07/06/2006 10.00?

    Seeing as I have 851 rows it would save me some time

  6. #6
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097

    Thumbs up

    Quote Originally Posted by TomBP
    No problem oldchippy

    It isn't over yet tho. I was stupid enough to make a different column for date and time. It looks like this:

    A1 ------- -- A2
    07/06/2006 10.00

    Now instead of changing the format of A1 and adding 10.00 manually is there a way I can merge those two cells so it shows 07/06/2006 10.00?

    Seeing as I have 851 rows it would save me some time
    No problem again, just do this in A3 and copy down 851 rows

    =A1+A2

    oldchippy

  7. #7
    Registered User
    Join Date
    09-02-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Calculating time difference

    Could someone tell me how to do exactly the same thing using a macro in excel? I have no idea about vba and macros and I really need to do it... Please help!

  8. #8
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097

    Re: Calculating time difference

    Hi,

    Please start a new thread

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

Closed 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