+ Reply to Thread
Results 1 to 4 of 4

Calculate "hours:minutes" difference between two "dates:times:minutes"

  1. #1
    Registered User
    Join Date
    11-21-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    99

    Calculate "hours:minutes" difference between two "dates:times:minutes"

    I need to calculate the difference in hours:minutes between two dates:hours:minutes. I attached a sample data. I simply deducted start date (column A - ) from end date (column B) and used a custom formatting in column C, such as "h:mm". I need to sort the "hours:minutes" difference from the smallest to largest.

    I have two problems that I cannot resolve.

    ColumnA ColumnB ColumnC
    2/20/2016 23:58 2/22/2016 10:15 10:16


    1. When I deducted =B2-B1 in column C, it returns incorrect hour difference if the date/time difference is greater than 24 hours. The formula seems doesn't account for the dates but only for hours and minutes.
    2. When I sort from small to large, it sorts from small to large only in two ranges: rows 2-25 (in yellow) and rows 26-97 (not highlighted).

    Any help would be greatly appreciated!

  2. #2
    Registered User
    Join Date
    11-21-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    99

    Re: Calculate "hours:minutes" difference between two "dates:times:minutes"

    Here is the file.

  3. #3
    Registered User
    Join Date
    02-26-2016
    Location
    VietNam
    MS-Off Ver
    2010
    Posts
    5

    Re: Calculate "hours:minutes" difference between two "dates:times:minutes"

    Custom formatting in column C "[h]:mm"
    Last edited by thuythanh; 02-27-2016 at 12:01 AM.

  4. #4
    Registered User
    Join Date
    11-21-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    99

    Re: Calculate "hours:minutes" difference between two "dates:times:minutes"

    Worked as a charm. Thank you so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 01-02-2014, 02:15 PM
  2. calculate difference between two dates and times in "days, hrs, mins, secs"
    By mankit87 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-03-2013, 04:27 AM
  3. Replies: 17
    Last Post: 06-09-2013, 01:06 AM
  4. Converting "x hours y minutes" into "z minutes" or "hr:mn"
    By MattChristensen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-24-2013, 03:41 PM
  5. Convert "Time Interval" in "hours : minutes : seconds" to seconds
    By deano27 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-28-2008, 09:07 AM
  6. time:how can i convert "22 hours 23 minutes" into 22:23 ?
    By Gary in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-03-2006, 05:50 AM
  7. Replies: 7
    Last Post: 05-08-2005, 04:06 PM
  8. How to sum a column of hours & minutes in format TEXT(C5-B5,"h:mm"
    By nosam in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-25-2005, 01:06 PM

Tags for this Thread

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