This is repeated for Tues, Weds and Thurs, Fri is almost the same except there is nothing after 12:30. The repeating target time value is 14.5 hours. So far I've created a list of durations for each 'Production', period and each 'Non production', period as decimal of 1 day so i was thinking of using some kind of 'Sum if' function? PS: I'm no whiz on excel but not a complete armature either.
Not only this but i want to exclude all of the non working times such as lunch breaks and tea breaks.
On a 24/7 calendar this would be a piece of cake but I'd like to calculate this for a typical working week Mon to Fri where Fridays are half day. I'm trying to calculate a recurring target time for work to be complete. I need some guidance on how to approach a problem. Hi all, New here and this is my first post.
