Hi,
In attached sheet row "A2 to AZ2" is the week date of every Monday and row "A3 to AZ3" hours for that week.
In week 4th Feb 2019 hours included from 4th Feb 2019 to 8th Feb 2019 and same for the other week.
So I need the formula in row "A6 to L6" which sum the weekly hours for that month from the row "A3 to AZ3".
In 25th Feb 1 day included for March and in 29th April 3 days for May so formula should sum the hours in Feb(40+40+40+32)= 152 hours and remaining 8 hours should sum under Mar month and in April month ( 40+40+40 +40 +16) = 176 hours remaining 24 hours should sum under May month
I have included my result in in row "A6 to L6".
Assumption: Monday - Friday working days.
Thanks,
Rahul
Bookmarks