Adjust the equation to determine the work Shift

[Hany ali]

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% ?

 

[vletm]

Hany ali
'raw valid data'
is that good data, 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 ))

'VBA'
... 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).

 

[Hany ali]

thanks very much ,mr Vletm
Of course, your words are set and you will try again with the appropriate employee to adjust the data drawn from the fingerprint device

 

[vletm]

Hany ali
Hmm? How to write? Do You really skip all or the most parts of my writings?
I can CONTINUE AFTER
You, Hany ali,
will upload my many times asked data.