Rota help needed with breaks

~CFM~

New Member
Joined
Jul 15, 2018
Messages
1
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.

 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Watch MrExcel Video

Forum statistics

Threads
1,099,011
Messages
5,466,014
Members
406,461
Latest member
Garrus

This Week's Hot Topics

Top