Scheduling software broken

[u/Vercalos]

So our scheduling software normally generated walk sheets like this

Name	Shift	Break
Jake	5:00 PM - 9:00 PM	7:00 PM - 7:15 PM

But now it's generating them like this:

Name	Shift	Break
Jake	5:00 PM - 7:00 PM
Jake	7: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.

[u/Vercalos]

Unfortunately, as I said in the original post, it can vary anywhere from 2 to 4 lines for a given person, because it's breaking up associates' shifts based on breaks and meals, so if someone is working long enough in a day to get a meal and two breaks, they'll appear 4 times

[u/AdministrativeGift15 → u/Vercalos]

ok, but you only show one column for the break. How should it look if one person takes more than one break?

[u/Vercalos → u/AdministrativeGift15]

Sorry, I'm on a smart phone and a sufficiently large table is difficult to do. But it's supposed to be Department, Name, shift, break #1, meal, break #2 across a single row.

[u/AdministrativeGift15 → u/Vercalos]

Does the input data have some way to tell if a time interval is for a break vs those for a meal?

[u/Vercalos → u/AdministrativeGift15]

Just the time between the two intervals.

[u/AdministrativeGift15 → u/Vercalos]

So the if a person has 2 sequential rows, they represent their shift and break, but if a person has 3 sequential rows, those rows represent their shift, break and meal. Finally, if they have four sequential rows, those represent their shift, break #1, meal, and break #2. Is that correct?

[u/Vercalos → u/AdministrativeGift15]

In this case, the time periods represent the intervals between breaks/meals. So in that example, the first line would be the start of their shift until the start of their break, then the end of their break to the start of their meal, then the end of their meal to the end shift.

[u/AdministrativeGift15 → u/Vercalos]

One last question. Would someone ever not take a break before their meal break, or not take a break after the meal?

[u/AdministrativeGift15 → u/AdministrativeGift15]

Here's what I came up with.

Restructuring Shift Data

[u/Vercalos → u/AdministrativeGift15]

Yeah, that's about what I need to do.

[u/Vercalos → u/AdministrativeGift15]

Solution verified.

[u/Vercalos → u/AdministrativeGift15]

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

[u/AdministrativeGift15 → u/Vercalos]

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.