tulsi_1940
1

OURS IS AN ORGANISATION OF 28 MEMBERS. WE USE biometric attendance system SYSTEM FOR CALCULATING ATTENDANCE. . IN ATTENDANCE EXCEL SHEET ONE NUMBER IS OCCURRING 25 TO 26 TIMES IN A MONTH WITH TIMINGS AND WE HAVE FIXED 9.30 IS AS OUR INCOMING TIMING AFTER 0945 WE USED TO PUT LATE MARK.
GUYS CAN YOU SUGGEST ME SOME EASY METHODS TO FIND OUT HOW MANY TIME A PARTICULAR NUMBER IS OCCURS AFTER 9:46 BY USING SOME FORMULAE

From India, Mumbai
jeevarathnam
639

Hi Tulsi You shall use the below formula =COUNTIF(E2127:E2135,">9.45") (=COUNTIF(Strat cell ref no:End Cell Ref no,">9.45"))
From India, Bangalore
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.