+ Reply to Thread
Results 1 to 2 of 2

calculate the time elapsed between start and finish dates

  1. #1
    Forum Contributor
    Join Date
    12-11-2013
    Location
    St Moritz, GR, Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    187

    calculate the time elapsed between start and finish dates

    test.xlsx
    I need to calculate the time elapsed between start and finish dates. I've figured the TODAY function, as explained here but I'm referring solely to dates in cells. How to?

  2. #2
    Forum Contributor
    Join Date
    12-11-2013
    Location
    St Moritz, GR, Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    187

    Re: calculate the time elapsed between start and finish dates

    I'm an idiot. =2nd cell - 1st cell gives me a number of days, format as number, no decimal places, add 1,000 comma separators, and I've a number of days.

    Thanks for reading, I hope I made you laugh at least.

+ 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 finish time given start time, working hours and job duration
    By swanseaexcel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-23-2012, 03:00 PM
  2. Replies: 4
    Last Post: 06-26-2012, 02:19 AM
  3. Replies: 5
    Last Post: 06-30-2011, 03:26 PM
  4. Replies: 1
    Last Post: 06-25-2010, 06:57 AM
  5. [SOLVED] how to calculate time start & time finish in quarter hour
    By Peter Wu in forum Excel General
    Replies: 3
    Last Post: 06-06-2006, 08:10 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