If you want to input 0.5 as half day leave. You can use the following formula for Half Day (HD) column:=SUMPRODUCT(–($D9:$AH9=”HD”)*0.5) It will look for all occurrences of “HD” within the range $D9:$AH9. Each “HD” will be counted as 0.5. You will need to format ...
Calculator.cpp │ ├── 12343 - Strange Simulation.cpp │ ├── 12345 - Dynamic len(set(a[LR])).cpp │ ├── 12345 - Dynamic len(set(a[LR]))[v2].cpp │ ├── 12347 - Binary Search Tree.cpp │ ├── 12355 - Consecutive Sums.cpp │ ├── 12357 - Ball Stacking.cpp │...
Calculator.cpp │ ├── 12343 - Strange Simulation.cpp │ ├── 12345 - Dynamic len(set(a[LR])).cpp │ ├── 12345 - Dynamic len(set(a[LR]))[v2].cpp │ ├── 12347 - Binary Search Tree.cpp │ ├── 12355 - Consecutive Sums.cpp │ ├── 12357 - Ball Stacking.cpp │...