Hi,
I want to calculate leaves taken by the employees. the only problem i face is when an employee apply for a half day leave, cause excel cannot determine a half day so I have to do it manually. I wanted the automatic calculation so I tried something:
I tried follow formula wherein E1 & F1 are made for half day leaves and G1 & H1 for full day leave. "11" is the holiday code and "$M$4:$M$11"is the list of holidays.
I divided the first formula with 2 to get half days as the result. The G1 & H1 cells are kept blank.
The output should have been 0.50 but it is calculating the blank cells (G1 & H1) as 1 and the output that I am getting is 1.50
=NETWORKDAYS.INTL(E1,F1,11,$M$4:$M$11)/2+NETWORKDAYS.INTL(G1,H1,11,$M$4:$M$11)
I am not so very technical so my apology for my choice of words. I hope my problem can be understood. is there any solution for this?