Struggling to make this work for me, probable cause - complete novice.
I'm changing roles and now need to be looking into creating rotas, I've created my template for it, but I need to take out 15 minutes (0.25) out of each shift over 5 hours for breaks.
I cheated a little and did the calculations off the rota to the right which won't be printed, my total is just using these numbers, however what I want it to incorporate is breaks taken both on the daily worked total, and the weekly total worked.
I can see it in my head, but can't work out the formula needed.
I'm changing roles and now need to be looking into creating rotas, I've created my template for it, but I need to take out 15 minutes (0.25) out of each shift over 5 hours for breaks.
I cheated a little and did the calculations off the rota to the right which won't be printed, my total is just using these numbers, however what I want it to incorporate is breaks taken both on the daily worked total, and the weekly total worked.
I can see it in my head, but can't work out the formula needed.