Santosh_Nayak
Asst. Manager Hr In A Construction Mnc
Mayur Shinde HR
Assistant Manager - Hr
+1 Other

Hi Friends :
I am working on payroll data. Now if a person has taken half day on three separate days as CL then what formula should I use in a excel so that the sum of all the CL taken during the month arrives at 1.5 days.
Please share inputs.
- Gia
Cite.Co is a repository of information created by your industry peers and experienced seniors made possible with help from our prime sponsors like:

TALENTEDGE Who provide a platform for "interactive anywhere learning". Courses from top reputed institutes like IIM, XLRI, MICA. View Courses

FACTOHR - Provides Customised Payroll, GPS Enabled Attendance, Travel, Performance Management, HRMS that can help streamline your organisation. Explore Features

Register Here and help by adding your inputs. Contributions From Other Members Follow Below...
Hi Gia, Can you please explain it briefly. Using the formula you can add the cells. Instead of that if you want any other formula then post your query clear.
Hi Santosh :
Thank you for responding. I am attaching a sample sheet. I want to plug in formula to calculate sum of Half day (HD) as per leave type (CL/SL,PL). The total leaves should appear in column `AJ' to `AM"
I am a little stuck here. Your inputs will help me.
- Gia

Attached Files
Membership is required for download. Create An Account First
File Type: xls Sample Sheet.xls (55.0 KB, 659 views)

hi Gia,
Use the below formula 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
Similarly, you can replace CL with PL and SL to calculate total number for leaves (either full day or half day)
ok Great to hear that.... Rather thanks to you to post such complicated question which was never thought off. I helped me to do some RnD on excel formula.. Cheers!!
Hi Gia attaching the file please take a look..........................................................................

Attached Files
Membership is required for download. Create An Account First
File Type: xls Sample Sheet.xls (40.5 KB, 354 views)

Thanks a lot Santosh !! Truly Citehr is super fabulous.... I feel absolutely elated with such a prompt response. Thanks to the Founders of this site also for providing us this outstanding forum - Gia
Add Reply Start A New Discussion






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™