+ Reply to Thread
Results 1 to 3 of 3

Finding the hours between two date/times.

  1. #1
    Registered User
    Join Date
    09-21-2018
    Location
    Redondo Beach, CA
    MS-Off Ver
    2016
    Posts
    13

    Finding the hours between two date/times.

    I am trying to find the difference in hours between to date/times in the format of [m/d/yyyy h:mm AM/PM]. I tried to subtract the 2 in a column and it seems it ignores the dates and only subtracts the times. I know that some of my results in the 'cycle time' column should exceed 24 hours, but it won't capture for some reason.

    screenshot.PNG

    Any help with formulas or functions that I could use would be greatly appreciated!

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,677

    Re: Finding the hours between two date/times.

    Format the result as [h]:mm
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    09-21-2018
    Location
    Redondo Beach, CA
    MS-Off Ver
    2016
    Posts
    13

    Re: Finding the hours between two date/times.

    Awesome, thank you!

+ 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. Finding Hours in two dates with times.
    By Smenice in forum Excel General
    Replies: 8
    Last Post: 01-26-2017, 04:34 AM
  2. Replies: 6
    Last Post: 01-30-2014, 06:58 AM
  3. [SOLVED] Difference between two Date and Times cell in Hours
    By kidengineer in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-23-2013, 04:05 AM
  4. Calculate working hours/mins between 2 date/times
    By MusicSOS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-02-2012, 04:59 AM
  5. finding # hrs between 2 date times
    By TechRetard in forum Excel General
    Replies: 10
    Last Post: 04-18-2010, 02:04 PM
  6. Replies: 1
    Last Post: 02-05-2009, 03:39 PM
  7. number of hours between two date/times
    By TBA in forum Excel General
    Replies: 6
    Last Post: 01-26-2006, 08:15 PM

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