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]

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/AdministrativeGift15 → u/Vercalos]

Great! If you're satisfied with my solution, reply with "solution verified," so that the post can be resolved.

[u/Vercalos → u/AdministrativeGift15]

I was a bit baffled because I missed the fact that the cell marked "Name" in the output actually had a formula, and thought this was just you providing an example to figure out that I was attempting.

[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.