Hi all, kindly suggest me for my following requirement.
I have opening leave balance with in the records and total leave availed during the current month, Required formulas for getting leave brk up of the availed leaves of the month meeting the availability of opening balance. I had almost derived at the formula. the problem which i'm facing now is
if there id 2.5 days of CL and 2 days of SL as opening balance and if an employee has availed 3 days of leave during the current month, mu formula split up shows it in the brk up as 2.5 days of CL and 0.5 days SL, which is inturn correct bt i dnt want a full day to be taken into split up of Half days. the desired result shud be of 2 CLs and 1 SL, then closing balance shud be 0.5 CL and 1 Sl in that case.. attached excel file for ready reference.
Guys, pls help me.
Divya...........
Bookmarks