by mhyven » Fri Dec 11, 2015 4:51 am
NoSparks,
please see attached file.
The very first time a particular barcode is scanned in yellow cell (D2)
--> the barcode number itself is written into column C
--> the current time is entered in column D
--> if the same barcode is scanned again in the yellow cell (D2), a pop-up will say “already timed-in”
The very first time a particular barcode is scanned in blue cell (D5)
--> if the barcode was scanned as “timed in” (or scanned in yellow cell – D2), then the current time is entered in column E; if not, then a pop-up will say “not yet timed-in”
--> the Lapsed time is calculated and entered into column F
--> if the same barcode is scanned again in the blue cell (D5), a pop-up will say “already timed-out”
The very first time a particular barcode is scanned in green cell (D8)
--> if the barcode was scanned as “timed in” (or scanned in yellow cell – D2) and “timed out” (or scanned in blue cell – D5), then a series of control number is entered in column B (the control number starts depending on the value entered in A2; must be numerically and ascending); if not, then a pop-up will say either “not yet timed-in and timed-out” or “not yet timed-out” whichever the case may be
--> the current date is entered in column G
--> if the same barcode is scanned again in the green cell (D8), a pop-up will say “process completed”
With the active cell will be shown in the window..
Thank you.
You do not have the required permissions to view the files attached to this post.