I have teachers all over the world and need to have them Give us their availability to teach. The right side of the page shows the times JST when students can schedule lessons. Students can schedule a 45 minute lesson on 15 minute intervals.

I want teachers to be able in a form to: 1) Select their time zone currently (whether standard or DST); 2) Mark times of each day that they are available; 3) have the form determine if there is an offset of the day (for example, 5:00 am JST may be the previous day on their schedule)

So on the sample sheet, when they mark their available times for each day, they should color the Excel sheet for available times and blank out the times not available. It should be able to show them the day offset either on the days or in a column on the right hand side.

I have some skills working with User forms, in VBA but I am also comfortable if there are other options more elegant. The real issue is user-friendly for the teachers.SampleAvailability.xlsx