Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Calculate Time difference between two Dates

  1. #1
    Join Date
    26th July 2006
    Posts
    10

    Calculate Time difference between two Dates

    Hi Ozgrid Community

    I知 stuck on this (probably simple calculation) I have two Rows of data.
    Each row contains a unique Name column and separate columns for Date, Hour and Minute.

    I would like to calculate the Time difference in Days, Hours and Minutes between the two Dates.

    I知 not sure if the way I致e set it up is the most practical.

    I値l attach the spreadsheet to better explain. If anyone could assist that would be great

    Thanks so much!
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    2nd November 2005
    Location
    Wessex
    Posts
    1,267

    Re: Calculate Time difference between two Dates

    I wouldn't do it that way, but that is just my preference, I would set it up as a timestamp, date and time, and manage those.

    However, you should at least cater for the sum of minutes exceeding 60, and hours exceeding 24, and adjust the other values accordingly.
    HTH

    Bob

  3. #3
    Join Date
    15th August 2006
    Posts
    3

    Re: Calculate Time difference between two Dates

    I have messed about with the formulas you had in your spreadsheet, using the TIME function to do all the base 60/base 24 stuff for you.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    --
    I'm not getting you down am I?

  4. #4
    Join Date
    26th July 2006
    Posts
    10

    Re: Calculate Time difference between two Dates

    Thanks Guys so much. It worked. Thanks

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,717

    Re: Calculate Time difference between two Dates

    See Also Date & Times in Excel for a better understanding of them.

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Calculate difference between two dates in sharepoint
    By Dave Hawley in forum Office 2007 Migration and Application Compatibility
    Replies: 0
    Last Post: May 10th, 2009, 03:32
  2. Calculate Difference In Days From 2 Dates
    By mcandoy in forum EXCEL HELP
    Replies: 1
    Last Post: August 1st, 2008, 03:31
  3. Calculate Day Difference From 2 Dates
    By ssweet in forum EXCEL HELP
    Replies: 7
    Last Post: July 31st, 2008, 11:13
  4. Calculate Workday Difference Between Dates/Times
    By cmarment in forum EXCEL HELP
    Replies: 4
    Last Post: June 20th, 2008, 08:13
  5. Calculate the difference between dates
    By krithika in forum EXCEL HELP
    Replies: 2
    Last Post: February 10th, 2005, 20:48

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
  •  
porno