+ Reply to Thread
Results 1 to 3 of 3

Calculating Time Elapsed

  1. #1
    Registered User
    Join Date
    02-26-2010
    Location
    Middletown, CT
    MS-Off Ver
    Excel 2004 Mac
    Posts
    4

    Calculating Time Elapsed

    Hello Excel folks,

    I have data with a column in date format containing the START date & time of a task.
    I also have a column containing the FINISH date & time of this same task.

    I would like to calculate the time elapsed to complete the task.

    The data in one of the Start time cells looks like this:
    09-Apr-2010 08:44:10

    And in another cell, the FINISH time looks like this:
    09-Apr-2010 08:51:22

    The format of these cells is DATE.

    Is there a way to calculate the time elapsed with this type of data?

    Your help is much appreciated!

    Al.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Calculating Time Elapsed

    You can just subtract one from the other, e.g. if start time/date is in A1 and end time/date in B1 then try this formula in C1

    =B1-A1

    custom format C1 as [h]:mm:ss
    Audere est facere

  3. #3
    Registered User
    Join Date
    02-26-2010
    Location
    Middletown, CT
    MS-Off Ver
    Excel 2004 Mac
    Posts
    4

    Re: Calculating Time Elapsed

    Thank you. That helps a bunch.
    I did try that originally, but the returned info made no sense. I think it was the formatting.


    Next question, I want to do an IF statement looking for values higher than 15 minutes.
    So, for cell D1 I will enter a formula.

    =If(C1>00:15:00,1,0)

    This does not work.

    How can I check for times more than 15 minutes???

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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