Sputnik1961
New Member
- Joined
- Dec 5, 2017
- Messages
- 3
I have been unable to get anything other than errors up to this point on this problem. All numbers are in hours
I have a set of data (3 columns by about 828 rows) that has the queue start time(D3:D830), work start time(E3:E830), and work completion time(F3:F830). These are the three columns the total number of rows will differ depending on how many parts come through in the given time period.
In a separate list, I have resource downtime [start of the downtime (W2:W10) and end of the downtime(X2:X10) ]. This is a 2 by roughly 8 (dependant on the time period).
I want to compare the two lists and determine if a part was affected by the downtime (e.g. was in the queue for a longer time because the resource was down). The end result is being able to gather metrics on downtime and its effect on total turn around time.
below is a section of the larger array and then the entire smaller array below that. My end result is I want the downtime column (right now showing #VALUE ! to show the amount time that overlaps between the Queue and completion time and anytime in the second table. So I want to first find the row that the times overlap, then determine the amount of overlap. I think the first part is my problem. I think Excel does not like that I am comparing one row to an entire array.
Thank you in advance for any help you can provide!
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
I have a set of data (3 columns by about 828 rows) that has the queue start time(D3:D830), work start time(E3:E830), and work completion time(F3:F830). These are the three columns the total number of rows will differ depending on how many parts come through in the given time period.
In a separate list, I have resource downtime [start of the downtime (W2:W10) and end of the downtime(X2:X10) ]. This is a 2 by roughly 8 (dependant on the time period).
I want to compare the two lists and determine if a part was affected by the downtime (e.g. was in the queue for a longer time because the resource was down). The end result is being able to gather metrics on downtime and its effect on total turn around time.
below is a section of the larger array and then the entire smaller array below that. My end result is I want the downtime column (right now showing #VALUE ! to show the amount time that overlaps between the Queue and completion time and anytime in the second table. So I want to first find the row that the times overlap, then determine the amount of overlap. I think the first part is my problem. I think Excel does not like that I am comparing one row to an entire array.
Thank you in advance for any help you can provide!
Queue Time | Start Time | Completion Time | Downtime |
<tbody>
</tbody>
<tbody>
</tbody>
Start Time | End Time | TAT |
17.61 | 168.26 | 150.64 |
1294.62 | 1615.49 | 320.87 |
1690.00 | 1773.67 | 83.67 |
3753.44 | 3789.30 | 35.86 |
4054.43 | 4129.25 | 74.82 |
5469.52 | 5476.09 | 6.56 |
5485.96 | 5593.34 | 107.38 |
5693.54 | 5719.38 | 25.83 |
<tbody>
</tbody>