J
jabster410
Hi guys, long time lurker first time poster. I'm looking for some Excel help with a formula I'm trying to write. The attached file has some sample data for a process line. Each row represents a "ping" to request data from the system. Each is time stamped and we are tracking line speed in column B, any fault values in column C, the fault status in column D, and I've added a formula in column E to show when the line is running over 200 feet/min. This is what I'm trying to calculate, the total time the line is running over 200 feet/min in a given 8 hour turn.
The problem is, the frequency of the "pings" sometimes provides two rows of data with the same time stamp. This is throwing off my caluclations of total time spent running over 200 feet/min. I've tried to come up with a formula in H2, but can't figure out how to tell it to continually reference the cell below it and not include any where those two cells are the same in the sum calculation. Could any of the Excel guru's take a look and provide any insight?
The problem is, the frequency of the "pings" sometimes provides two rows of data with the same time stamp. This is throwing off my caluclations of total time spent running over 200 feet/min. I've tried to come up with a formula in H2, but can't figure out how to tell it to continually reference the cell below it and not include any where those two cells are the same in the sum calculation. Could any of the Excel guru's take a look and provide any insight?