I have three diferents arrays of numbers and i know wich is the origin when i see the serial, but how can idetify with a formula e.g
12AA1234
12A1A123
12A1234A
FIRST TWO DIGITS MENS YEAR 12
THREE AND FOUR DIGITS ARE A LETTERS MEANS ONE ORIGIN
THREE AND 5 DIGITS MEANS SECOND ORIGIN
THREE...
and try to identify the shift between labor hours per example
7:30 am to 15:30 PM 1 shift
15:30 pm to 23:00 PM 2 shift
23:00 pm to 7:29 AM 3 shift
I did convert the hours as follow =TEXT(A1,"hhmm"), and in other cell the condition
=IF(a29<1530,1,2))