+ Reply to Thread
Results 1 to 3 of 3

Excel Formula for Time Difference Between Dates

  1. #1
    Registered User
    Join Date
    05-12-2020
    Location
    Mechanicsburg, PA
    MS-Off Ver
    2016
    Posts
    21

    Excel Formula for Time Difference Between Dates

    Trying to calculate hours and minutes between time and date(s) that may carry over to the next day.Any help is greatly appreciated.

    Please see previous thread below...

    Thanks so much!

  2. #2
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2404
    Posts
    1,259

    Re: Excel Formula for Time Difference Between Dates

    This is a basic formula that covers for cases when end time is on the next day and smaller than start time.
    IF(start time<end time,end time-start time,end time-start time+1)

    Good luck!

  3. #3
    Registered User
    Join Date
    05-12-2020
    Location
    Mechanicsburg, PA
    MS-Off Ver
    2016
    Posts
    21

    Re: Excel Formula for Time Difference Between Dates

    I still get an error with this formula.

    Any help is greatly appreciated.

+ 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. Excel Formula for Time Difference
    By SeaLawyer in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-22-2020, 08:28 PM
  2. Replies: 3
    Last Post: 08-12-2017, 01:48 AM
  3. [SOLVED] Calculating difference between 2 dates in excel 2003 - formula not working correctly
    By cf7046 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-03-2013, 10:18 PM
  4. Excel Formula trying to calculate difference between two dates
    By carolynb in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-03-2010, 09:35 AM
  5. [SOLVED] How can I use a time difference in a subsequent formula in Excel?
    By Niek Otten in forum Excel Formulas & Functions
    Replies: 41
    Last Post: 09-06-2005, 06:05 PM
  6. [SOLVED] How can I use a time difference in a subsequent formula in Excel?
    By numberman37 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] How can I use a time difference in a subsequent formula in Excel?
    By numberman37 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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