Calculating extracted data to get run times of equipment

**neffd** · 09-09-2019, 03:53 PM

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.

**FlameRetired** · 09-09-2019, 08:48 PM

Try in I2:M4677

Formula:

Please Login or Register  to view this content.

and format for time.

**neffd** · 09-10-2019, 06:38 AM

Perfect!!! Thanks!!!

**FlameRetired** · 09-10-2019, 04:17 PM

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.

**chief_abound** · 09-11-2019, 09:20 AM

Office Insider

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

Calculating extracted data to get run times of equipment

LinkBack

Thread Tools

Rate This Thread

Display

Calculating extracted data to get run times of equipment

Re: Calculating extracted data to get run times of equipment

Re: Calculating extracted data to get run times of equipment

Re: Calculating extracted data to get run times of equipment

Re: Calculating extracted data to get run times of equipment

Thread Information

Users Browsing this Thread

Similar Threads

Counting equipment and also the total of times that item has been orhave been ordered?????

Problem with the extracted data

calculating inter arrival times and statistical distribution of these times

Calculating difference between two times through a column of data

Calculating date/time overlap for multiple equipment

Calculating APR

Help: calculating hours for various equipment

Bookmarks

Bookmarks

Posting Permissions