Attendance Data

[Lasantha]

Dear Team,

Kindly look into the attached template. Is it possible to identify those who exit early by the Shift.

(Shift start and end time has given).

Thank you.
Lasantha.

 

[pecoflyer]

Duplicate post https://chandoo.org/forum/threads/late-entries.46218/#post-275326

 

[Lasantha]

Duplicate post https://chandoo.org/forum/threads/late-entries.46218/#post-275326

Hi,

I am checking whether it is possible to get who exit early.

Thank you very much , you helped me to resolve one part.

 

[Peter Bartholomew]

= MOD(RealOutTime - XLOOKUP(Shift, Shifts, EndTime), 1) > 0.5

Make sure you inform forum contributors if your problem is solved on another forum (that goes both ways)

 

[Lasantha]

= MOD(RealOutTime - XLOOKUP(Shift, Shifts, EndTime), 1) > 0.5

Make sure you inform forum contributors if your problem is solved on another forum (that goes both ways)

thank you.