Data Subraction

[monsterdrink]

I have a list of data with item numbers. This item number is associated with different status like received,put away and invoiced. The issue is, in the data set I have only one line of the data with received status at particular time but there are many lines with put away status at different time. I need to subtract the Received Time with the multiple put away time.

Example

Item 1 - Received - 12:01 PM
Item 1 - Put away - 12:04 PM ( Need to subtract 12:04 with 12:01 PM which is 3 min)
Item 1 - Put away - 12:07 PM (Need to subtract 12:07 with 12:01 PM which is 6 min)
Item 1 - Put away - 12:10 PM (Need to subtract 12:10 with 12:01 PM which is 9 min)
Item 2- Received - 12:09 PM
Item 2- Put away - 12:24 PM (Need to subtract 12:24 with 12:09 PM which is 15 min)
Item 2- Put away - 12:36 PM (Need to subtract 12:36 with 12:09 PM which is 27 min)

Doing this for one item number is easy but I need to do it for so many different item numbers. I dont know what is the easy way to do

[Richard Buttrey]

Hi and welcome to the forum.

Would you upload the workbook so that we can see the precise layout. These things are always easier if we can see the context.

[63falcondude]

If your data is in A2:C8 (headers in row 1), you can use this formula formatted as Custom h:mm in D2 copied down

=IF(COUNTIF(A$2:A2,A2)-1,C2-MIN(IF($A$2:$A$8=A2,$C$2:$C$8)),"") Ctrl Shift Enter

[Glenn Kennedy]

Here's an ordinary formula that does the same thing:

=IF(B2="Received","",C2-LOOKUP(2,1/($B$2:$B2="Received"),$C$2:$C2))