+ Reply to Thread
Results 1 to 5 of 5

Calculating extracted data to get run times of equipment

  1. #1
    Registered User
    Join Date
    09-05-2019
    Location
    Batesville, Indiana
    MS-Off Ver
    365 ProPlus
    Posts
    6

    Calculating extracted data to get run times of equipment

    I have extracted data that shows when my dryers and iron were running. (See attached) I need a formula that subtracts the off time from the on time. I can do this manually but this is a months worth of data. Any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365
    Posts
    10,499

    Re: Calculating extracted data to get run times of equipment

    Try in I2:M4677
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and format for time.
    Dave

  3. #3
    Registered User
    Join Date
    09-05-2019
    Location
    Batesville, Indiana
    MS-Off Ver
    365 ProPlus
    Posts
    6

    Re: Calculating extracted data to get run times of equipment

    Perfect!!! Thanks!!!

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365
    Posts
    10,499

    Re: Calculating extracted data to get run times of equipment

    You are welcome. Glad to help. Thank you for the feedback and added rep.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  5. #5
    Forum Contributor
    Join Date
    09-18-2015
    Location
    Republic of Korea
    MS-Off Ver
    2010
    Posts
    296

    Re: Calculating extracted data to get run times of equipment

    Office Insider

    I2 --> =IF(D2="Off",$C2-XLOOKUP("On",D$2:D2,$C$2:$C2,0,-1),"")

+ 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