thanks mr. NARAYANK991
Exactly this is the problem of not getting clear and interpreted data from the fingerprint device
thanks alot mr. @vletm
sorry ,what you want to be as raw valid data ?
and if by VBA ,will be correct 100% ?
'raw valid data'
is that gooddata, which can get from the fingerprint device
... basic timestamp and employee information.
'raw' means 'raw' - not even sorted! ps. If You would like to solve eg the whole November, then You should have data from 31-Oct ... of course!
(( so far that format of timestamp is ... something ))
... Have You skipped all my writings?
With clear rules many thing are possible.
The data will show how employees has used the fingerprint device ---- that's all!
Your given information ... hmm? ... gives many possibilities that it can use
... this and that way (this way is positive for both sides).