Calculating 0.5 leave days

[SRoux]

Hi,

I have created an annual leave calendar with drop down lists for each day making it possible to select the type of leave (annual leave (1day) and annual half day leave (0.5day), in a table below I have a summary where the annual leave for each month is added up, providing an annual total at the end with the amount of days available. I managed to let it autosum the annual leave days, but it calculates the half days as one whole day, how do I assign the value of 0.5 days to the annual half day leave when it is selected from the drop down list.

Regards,

 

[steve the fish]

Hi. What table?

 

[FormR]

Hi, welcome to the forum!

It's not clear what gets selected from the dropdown but maybe you could adapt something like this.

Excel 2013/2016
	A	B	C
1	1day		3.5
2	0.5day
3	0.5day
4	1day
5	0.5day
Sheet1

Cell Formulas
Range	Formula
C1	=SUMPRODUCT(COUNTIFS(A:A,{"1day","0.5day"}),{1,0.5})