Dear All,
I want to calculate if an employee coming late for 3 times in a month than it should be consider as one half day, now my concern is what formula to use in excel. I am manually marking the attendance where in i have used conditional formatting, considering L for late mark.
Please help me with an formula.
Regards,
Pinkal
From India, Mumbai
1I want to calculate if an employee coming late for 3 times in a month than it should be consider as one half day, now my concern is what formula to use in excel. I am manually marking the attendance where in i have used conditional formatting, considering L for late mark.
Please help me with an formula.
Regards,
Pinkal
From India, Mumbai
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.
EXCEL FORMULA.xls