MAKING A AUTOMATIC BREAK SHEET

Blend43 1 Reputation point
2022-04-30T06:02:07.557+00:00

197886-screenshot-2022-04-30-155622.png

Hi guys, I'm hoping i get can some help in regards to creating an automatic break sheet..

This is a break sheet for my work currently.. We have a site that shows our workers and how long their shifts are.. We need too manual create a break sheet every day. In Aus, worker are required to take breaks depending on their shift length
If you work 8 hours or more, you-get 1x 30 min break and 2x 15min breaks

If you work 5 hours you get 1x 30 min break, and 1x 15min break
If you work 4 hours you get 1x 15min break only.

i have provided an image on how it looks with a couple of workers.. The workers also must work at lease 2 hours before having their first break... AND if you work for 8 hours you must have a 15 minute break first, then your 30 minute break... Anyways

Just wondering, is there any template out there that I could use, that when I type in the name and shift length, it automatically puts in their break on the right?
It would make it so much easier and faster, I need as much help as possible in creating this.

Microsoft 365 and Office Excel For business Windows
Developer technologies Visual Basic for Applications
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.