Hi there. I am looking to generate data for appointments. So each excel row will have 2 columns: date and time. Preferably, someone should enter the initial day, how many days and also initial time and time intervals and then the system should be able to populate data which will contain for each date all appointment times. Example like this:
9/1/2021 8:00:00
9/1/2021 8:30:00
9/1/2021 9:00:00
9/1/2021 9:30:00
9/1/2021 10:00:00
9/1/2021 10:30:00
9/2/2021 8:00:00
9/2/2021 8:30:00
9/2/2021 9:00:00
9/2/2021 9:30:00
9/2/2021 10:00:00
9/2/2021 10:30:00
So for date/time sequence I know I have to use this: =SEQUENCE(B1, 1, B2, B3) and I also found a nice example here:
https://www.ablebits.com/office-addins-blog/2020/08/26/date-sequence-excel-fill-date-series/
if you check this area: [I]Create a year sequence in Excel[/I] you will see that it does the same but for years. Instead of having one date and all times and then next date etc. it has the same with dates and years but I have difficulty adjusting this to what I need. Any help is much appreciated.
Thank you in advance
