+ Reply to Thread
Results 1 to 6 of 6

# of Hours between 2 dates with time

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    # of Hours between 2 dates with time

    i have 2 cells with following Time stamp:

    10/13/2008 8:28 AM

    10/15/2008 11:44 AM

    I need formula to calculate # of hours and min between the two..


    Please help

    Thank u,

    Riz Momin

  2. #2
    Registered User
    Join Date
    09-01-2008
    Location
    Houston, TX
    Posts
    70
    If dates are in A1 and B1 then in C1 enter =B1-A1 & format [h]:mm
    GMc

  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434
    This would not give correct result.
    With the above data, this would give 3hr 16 min ( 3:16) which is not correct hr:mm

    Help

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570
    Try: 24*(B1-A1), with cell formatted as number (=51.27 hrs)
    Ben Van Johnson

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Quote Originally Posted by 19fortysix
    If dates are in A1 and B1 then in C1 enter =B1-A1 & format [h]:mm
    Quote Originally Posted by rizmomin
    This would not give correct result. With the above data, this would give 3hr 16 min ( 3:16) which is not correct hr:mm
    No, it would show 51:16 if formatted as 19fortysix suggested: [h]:mm
    Entia non sunt multiplicanda sine necessitate

  6. #6
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434
    This works, great,

    Thank you...

    Riz Momin

+ 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. calculate the number of working hours between two dates
    By sureshchinna_sb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-29-2012, 09:57 AM
  2. Formula: Adding Hours to Dates
    By Grock258 in forum Excel General
    Replies: 6
    Last Post: 08-04-2008, 08:07 PM
  3. hours between dates??
    By spinkung in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-24-2008, 10:10 AM
  4. calculating total hours between dates
    By ccsooner in forum Excel General
    Replies: 14
    Last Post: 05-03-2008, 04:19 PM
  5. Data Validation for dates & time exceeding 24hrs
    By Zyphon in forum Excel General
    Replies: 4
    Last Post: 08-30-2007, 04:37 AM

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