tonywatsonhelp
Wellknown Member
 Joined
 Feb 24, 2014
 Messages
 2,744
 Office Version

 365
 2019
 2016
 Platform

 Windows
Hi Everyone,
Ok so i'll create an example below as this is a bit hard to explain,
but i'm trying to work out holiday hours for our employees
so what i have is a 4 week holiday (no one can take more than 4 weeks at a time) but a lot of people start or end there holidays with a half day,
so heres my problems
in the grid below ive tried to show my setup and what i have
So heres the rules i need,
we have 4 weeks,
holiday can start in week 1 or week 2
and can end in week 1,2,3,4
so I need formulas that take into acount if there is a holiday and if there is a half day,
if so take any Half Start Day off the first week of day, and Half Day End off the last week
sound simple but i've been playing around with this for hours now,
please help if you can,
thanks
Tony
Ok so i'll create an example below as this is a bit hard to explain,
but i'm trying to work out holiday hours for our employees
so what i have is a 4 week holiday (no one can take more than 4 weeks at a time) but a lot of people start or end there holidays with a half day,
so heres my problems
in the grid below ive tried to show my setup and what i have
A  B  C  D  E  F  G  H  I  J  K  
Week 1 days  Week 2 Days  Week 3 Days  Week 4 Days  Half Day Start  Half day End  Days WK1  Days WK2  Days WK3  Days WK4  
5  5  3  yes  yes  4.5  5  2.5  0  
0  3  yes  yes  0  2  0  0  
1  1  no  yes  1  .5  
So heres the rules i need,
we have 4 weeks,
holiday can start in week 1 or week 2
and can end in week 1,2,3,4
so I need formulas that take into acount if there is a holiday and if there is a half day,
if so take any Half Start Day off the first week of day, and Half Day End off the last week
sound simple but i've been playing around with this for hours now,
please help if you can,
thanks
Tony