Thanks for looking at my post.
I have sheet called Plan.
Column A will be auto generate data. I have managed row 6 to work. I have issue with rest of the rows as I struggled to get formula for column C. What I need is following logic please.
1. Shift start at 6 am Monday till Friday
2. Shift finish at 4PM on Monday to Thursday and on Friday its 2PM
3. Sat and sun off
What I am looking for is, Depending upon time in the column G I wanted to auto generate the plan and if the work finish in after shift time or falling in the weekend I wanted to start on the next working day at 6 am.
I have given some manual examples in the row 7, 8 and 9
Is there any formula I can use in column C for this condition please?
Currently I use =IF(B6=0,0,IF(OR(I6<>I5,H5>=119),85,C5+D5)) in the column c but that’s for different condition. You can see this formula in the row 10 and column c
Thanks again