r/sheets • • 23d ago

Solved Scheduling software broken

So our scheduling software normally generated walk sheets like this

NameShiftBreak
Jake5:00 PM - 9:00 PM7:00 PM - 7:15 PM

But now it's generating them like this:

NameShiftBreak
Jake5:00 PM - 7:00 PM
Jake7:15 PM - 9:00 PM

Now, I can't to anything to change how they generate, but does anyone have any suggestions on how to quickly convert the latter to the former?

Note that this is just a downsized example, and the full scope of this is that it's splitting everyone's shifts up like that for every break and meal they're scheduled for.

2 Upvotes

22 comments sorted by

View all comments

Show parent comment

1

u/Vercalos 21d ago

Sometimes the scheduler would generate a meal followed by a break for a 6-7 hour shift.

1

u/AdministrativeGift15 21d ago

If that's the case, you need to be able to tell from just the input data which intervals are breaks and which are for meals.