+ Reply to Thread
Results 1 to 3 of 3

Calculating the Difference in Time

  1. #1
    Registered User
    Join Date
    01-22-2013
    Location
    Palmerston North, New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    28

    Calculating the Difference in Time

    Hello there,

    Please help me calcualte the difference between the two times in Column 1 e.g. I need the time difference between the A3 and A2 in cell B3. Do you have a macro that could help me calculate the time difference in minutes and seconds?

    Please help me out with this.

    Thanks in Advance.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,450

    Re: Calculating the Difference in Time

    All you need is to subtract the smaller number from the larger and format the cell to show time.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-22-2013
    Location
    Palmerston North, New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    28

    Re: Calculating the Difference in Time

    Thank you for that. Will Update the thread with a thank you. I have a new query however....

+ 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