Google Spreadsheets: Creating a schedule more easily

[ceponatia]

Hey everybody,

At work I have to maintain a schedule for my boss in Google Spreadsheet that has 5 appointments per day, Tuesday thru Friday. Right now that involves me writing in the date and then copying and pasting it in 5 rows and then copying and pasting the time slots (9, 10, 11, 1:30, and 2:30) in the column next to them. Is there a way to just create a list from now until say a year from now of Tuesday-Friday cells? I don't think I can attach a picture so I'll kind of illustrate below what it looks like...

Wed, May 24 2017 9:00AM
Wed, May 24 2017 10:00AM
Wed, May 24 2017 11:00AM
Wed, May 24 2017 1:30PM
Wed, May 24 2017 2:30PM

Then in between each day there is a red line and in between each month there is a blue line, just for organization. I don't mind manually doing that if I have to but if there's also an automatic way to do that, that'd be sweet. Thanks for any help!

 

[boosted1g]

Why are you making a schedule in a spreadsheet vs calendar?

 

[leoscott]

I don't use Google spreadsheets, but do use Excel. This would be easy with Excel using it's autofill capability. If you can copy multiple cells into Google spreadsheets, just create it in Excel and copy and paste the result into Google spreadsheets.

 

[ceponatia]

Why are you making a schedule in a spreadsheet vs calendar?

Calendar doesn't do what we need.

 

[ceponatia]

I don't use Google spreadsheets, but do use Excel. This would be easy with Excel using it's autofill capability. If you can copy multiple cells into Google spreadsheets, just create it in Excel and copy and paste the result into Google spreadsheets.

Do you have a link to a tutorial on how to do this? I'm a spreadsheet noob.