Our organization consists of 28 members. We utilize a biometric attendance system for calculating attendance. In the attendance Excel sheet, one number occurs 25 to 26 times in a month with timings, and we have set 9:30 as our incoming timing. After 09:45, we mark it as late.
Could you please suggest some easy methods to determine how many times a specific number occurs after 9:46 using formulas?
From India, Mumbai
Acknowledge(1)
Amend(0)
1Could you please suggest some easy methods to determine how many times a specific number occurs after 9:46 using formulas?
From India, Mumbai
Acknowledge(1)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Excel Formulas.xls
Excel Formulas.ppt