Hi,

I'm new to this site and I don't know how to post a new thread so forgive me if replied to this thread with a different question.
I just need help for below data. I have the data available for column A,B,& C and I want the result showing in column D&E.
Can someone help me with the formula for D&E. Thanks in advance.

A B C D E
JIL MALAKIE 1232 AB20 1234F 117 3/9/2016 8:45 N*=.96 ANA-1232-1234F 09/Mar/16 08:45:00
MALAKIE 1232 AB20 1234 118 3/7/2016 7:20 S=1.43 ANA-1231-1234 07/Mar/16 07:20:00

Thanks,
goya