Trouble with schedule times

[RazrHog]

Sorry, this is probably a really easy one for you guys, but I have spent quite awhile trying to figure it out.

I downloaded the student schedule template provided by Microsoft. Link: Student schedule

I don't actually want to use it as a student schedule, but instead a daily schedule of tasks for myself, but that is irrelevant.

When I put in a time (doesn't matter the increment), it will always spill over into the next time. For instance, if you put it as 30 minute increments up at the top, on the default information listed, it will put the default listed Health & Fitness class lasting for three 30 minute increments (until 12:30, when it only should go to 12:00). I can fix it by subtracting 1 minute (or even 1 second). For instance, in the default example, if it is changed to 11:59, it will display correctly.

Can anyone figure out how to fix it so that it will display correctly as listed?

Thank you very much for any help that anyone feels they might be able to give.

Here are a couple screenshots with red boxes around the relevant example I described above. (this information is in the default template above at the Microsoft link)

 

[ebea]

I can see, after I looked one more time on your Pictures, that you have not changed time in Sheet "Class list". Change the interval there, to your case (11:00 - 11:30), and it change in Sheet "Class Schedule" as well.
In your name manager, the number to "shift" below or above the set time, are: =0,999305555555556
If you by example chage that to =1,1, you will see, that your marked schedule change, no matter if you set to half an Hour, or not.

 

[Fluff]

Once again that has nothing to do with anything. It is the cell formula that needs changing.

 

[ebea]

Once again that has nothing to do with anything. It is the cell formula that needs changing.

Okay. Let it be so. It works okay by me. As written, remember to change the Sheet "Class list" schedule as well. Then it works.

 

[Fluff]

If the OP changes the time to 11:30 instead of 12:00 & changes the time interval to 15Mins, then it won't show anything for 11:45 till 12 which would be wrong.
Just changing the <= to < as I suggested, will fix everything. That is the only thing that needs changing.

 

[RazrHog]

I wish I could just change the cell, Fluff, but it doesn't display correctly. I am not sure how I show you other than maybe record a video or something?

 

[ebea]

If the OP changes the time to 11:30 instead of 12:00 & changes the time interval to 15Mins, then it won't show anything for 11:45 till 12 which would be wrong.
Just changing the <= to < as I suggested, will fix everything. That is the only thing that needs changing.

This is set to the time you write (Start - End). 11:30 to 12:00.
So I can't see what you mean by your comment. As written, it works perfectly, if OP change the time in Sheet "Class list". And still, the CF, mark the correct schedule, for the actual day.

 

[Fluff]

I wish I could just change the cell, Fluff, but it doesn't display correctly.

Can you just describe what happens when you change the formula?
Do you see the formula in the cell, do you get an error?

 

[RazrHog]

This is set to the time you write (Start - End). 11:30 to 12:00.
So I can't see what you mean by your comment. As written, it works perfectly, if OP change the time in Sheet "Class list". And still, the CF, mark the correct schedule, for the actual day.

View attachment 60129

If I change it to 11:00-11:30, it still shows for an hour if it is changed to 30 minute increments. (or in your example, it shows for 45 minutes, even though it is a 30 minute schedule)

 

[Fluff]

So I can't see what you mean by your comment.

The comment was referring to your previous post, which has nothing to do with what you are saying now.

 

[Fluff]

If I change it to 11:00-11:30, it still shows for an hour if it is changed to 30 minute increments. (or in your example, it shows for 45 minutes, even though it is a 30 minute schedule)

As I said it is the formula that needs to be changed & nothing else.
I have to go for a bit, but will download the file when I get back.