Hi Friends, I am working on payroll data. Now, if a person has taken a half-day on three separate days as CL, then what formula should I use in Excel so that the sum of all the CL taken during the month arrives at 1.5 days? Please share inputs.
Regards,
Gia
From India, Pune
Acknowledge(0)
Amend(0)
95Regards,
Gia
From India, Pune
Acknowledge(0)Amend(0)
Thank you for responding. I am attaching a sample sheet. I want to plug in a formula to calculate the sum of Half Day (HD) as per leave type (CL/SL, PL). The total leaves should appear in columns AJ to AM. I am a little stuck here. Your inputs will help me.
Regards,
Gia
From India, Pune
Acknowledge(0)Amend(0)
Regards,
Gia
From India, Pune
Acknowledge(0)Amend(0)
Hi Gia, use the formula below in your "Leave (CL)" column. It will give you the correct figure:
=((COUNTIF(F5:AH5, "CL HD"))/2)+((COUNTIF(F5:AH5, "CL")))
Verify and let me know if it comes out to be correct.
From India, Pune
Acknowledge(2)Amend(0)
=((COUNTIF(F5:AH5, "CL HD"))/2)+((COUNTIF(F5:AH5, "CL")))
Verify and let me know if it comes out to be correct.
From India, Pune
Acknowledge(2)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.
LEAVE ENCASHMENT NOT INCLUDED IN WAGES FOR P. F. CALCULATION.pdf
Leave Encashment & Salary Calculation.xls x