Find Name/Time match Name on another sheet

Under the SCHEDULE tab, find the name and the TIME UNDER THE SUNDAY column
In the SUNDAY tab, match the name, find the time range and put a ‘1’ in that column.

Then, find the names and the MONDAY times….repeat….
*attached sheet (no vba)

in cell c4:
=IF(COUNTIFS(Schedule!$B:$B,$B4,INDEX(Schedule!$C:$I,,MATCH($B$1,Schedule!$C$1:$I$1,0)),TEXT(C$2,"h:mm")&"-"&TEXT(C$3,"h:mm")),1,"")

Please describe in what way the specs have changed - details, please.

You should not have edited the opening post - that is extremely confusing. I will sort it out - please always add changes to specs in new posts to the thread.

New specs:

There is a change in specs that wasn't explained to me.
It was first explained as it would only be a 1/2 hour range.
What it changed to was a working time range. Instead of 6:00-6:30 - - it is actually 6:00-17:30.

In the SOLVED version, the time range as just 1/2 an hour - i have included the solved version in this post.

What needs to be done, for example, if the time is 9:00-10:30
Then a '1' needs to be placed on the correct day tab under the 9:00-9:30 column, and the 9:30-10:00 column, and the 10:00-10:30 column
I've attached the file - - -

For example, if Amy worked SUNDAY, 6:30-8:00----on the SUNDAY tab, she would have a '1' under the 6:30-7:00 column
and another '1' under the 7:00-7:30 column and another '1' under the 7:30-8:00 column

Please try at C4 drag across and down

Formula:

Please Login or Register  to view this content.

Happy to help.
Thank for mark topic Solved.

Small change, You can remove the "--" in front of MID.

Formula:

Please Login or Register  to view this content.

I have, for a second time, reinstated your first post. In post #7 I asked you not to edit your first post, yet you have ignored this request and done so again. You should never remove details form posts as this is a database for members to use to find help on similar issues. By post-editing any of your posts, you are effectively vandalising the thread and rendering it useless. If you are requested not to do something by a moderator, please do not ignore that request.