Forum Discussion
ajmal_pottekattil_yoousuf
May 01, 2024Iron Contributor
Conditional Formatting
- The employee comes late above 8:15 am (For Late Comming 15 min is allowable) After 15 minutes only considered late comming.
- The employee is Absent "A-A"
- If the Employee is not Punching Either in the morning or Evening.
I have inserted the formulae. Are the results not correct? I think it should fit.
- dscheikeyBronze Contributor
Please have a look at my examples of conditional formatting. Is that what you were looking for? If not, please contact me again.
- ajmal_pottekattil_yoousufIron Contributor
dscheikey Thanks for the valuable support. It is working perfectly.
It is possible to find the Employees are late and not punching (in/out) using conditional formatting.
I am also struggling to find the count.
- Absent
- Late punching count.
- In/out Not punching properly count.
- Late punching and In / out Punching properly count.
- dscheikeyBronze Contributor