TeamOSupremeO
New Member
- Joined
- May 16, 2018
- Messages
- 4
[TABLE="width: 500"]
<tbody>[TR]
[TD]ID
[/TD]
[TD]Assigned Queue
[/TD]
[TD]Queue Entry Time
[/TD]
[TD]Time in Queue
[/TD]
[/TR]
[TR]
[TD]AAA
[/TD]
[TD]Test
[/TD]
[TD]12/12/17 3:00
[/TD]
[TD](need calculation)
[/TD]
[/TR]
[TR]
[TD]BBB
[/TD]
[TD]Production
[/TD]
[TD]6/1/18 7:00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BBB
[/TD]
[TD]Test
[/TD]
[TD]3/2/18 3:00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CCC
[/TD]
[TD]Quality Check
[/TD]
[TD]6/12/18 2:00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CCC
[/TD]
[TD]Production
[/TD]
[TD]6/25/18 4:00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AAA
[/TD]
[TD]Quality Check
[/TD]
[TD]12/25/17 6:00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BBB
[/TD]
[TD]Quality Check
[/TD]
[TD]5/23/18 4:30
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CCC
[/TD]
[TD]Test
[/TD]
[TD]6/1/18 8:00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AAA
[/TD]
[TD]Production
[/TD]
[TD]1/19/18 12:30
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have unique ID items that appear in multiple lines within a workbook, not necessarily one line after the other. Each line represents a new assignment (queue) for that item ID. The line contains the date/time when the unique ID was assigned to the new queue, but not how long it stays in the queue before new assignment.
I am looking for a formula to calculate the time spent in each queue. I would need to subtract the 1st chronological assignment time from the 2nd chronological assignment time, the 2nd chronological assignment time from the 3rd chronological assignment time, etc. etc. etc. How can I accomplish this?
<tbody>[TR]
[TD]ID
[/TD]
[TD]Assigned Queue
[/TD]
[TD]Queue Entry Time
[/TD]
[TD]Time in Queue
[/TD]
[/TR]
[TR]
[TD]AAA
[/TD]
[TD]Test
[/TD]
[TD]12/12/17 3:00
[/TD]
[TD](need calculation)
[/TD]
[/TR]
[TR]
[TD]BBB
[/TD]
[TD]Production
[/TD]
[TD]6/1/18 7:00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BBB
[/TD]
[TD]Test
[/TD]
[TD]3/2/18 3:00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CCC
[/TD]
[TD]Quality Check
[/TD]
[TD]6/12/18 2:00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CCC
[/TD]
[TD]Production
[/TD]
[TD]6/25/18 4:00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AAA
[/TD]
[TD]Quality Check
[/TD]
[TD]12/25/17 6:00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BBB
[/TD]
[TD]Quality Check
[/TD]
[TD]5/23/18 4:30
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CCC
[/TD]
[TD]Test
[/TD]
[TD]6/1/18 8:00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AAA
[/TD]
[TD]Production
[/TD]
[TD]1/19/18 12:30
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have unique ID items that appear in multiple lines within a workbook, not necessarily one line after the other. Each line represents a new assignment (queue) for that item ID. The line contains the date/time when the unique ID was assigned to the new queue, but not how long it stays in the queue before new assignment.
I am looking for a formula to calculate the time spent in each queue. I would need to subtract the 1st chronological assignment time from the 2nd chronological assignment time, the 2nd chronological assignment time from the 3rd chronological assignment time, etc. etc. etc. How can I accomplish this?