nested if

[longba]

my IF statement would be sound like this.

IF range("J2:J500") = "ATP" reference cells in same row part#, serial#, date, time.

then find where the above "ATP" cells part#, serial# match the same part#, serial# but this time range("J2:J5000") = "FTP 1"

then i want to subtrace the "FTP 1" date/time stamp from the "ATP" time/date stamp

and save the difference to another worksheet under
Part#
Serial#
Cycle time = above diference



I have tried many different ways to filter the data then write an IF but I can't seem to nail it down.

any help is appreciated. Thanks in advance.

Respectfully,
BL

 

[longba]

*TYPO*

Subtract not subtrace