Combine workday and sequence

%3CLINGO-SUB%20id%3D%22lingo-sub-2772556%22%20slang%3D%22en-US%22%3ECombine%20workday%20and%20sequence%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2772556%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there.%20I%20am%20looking%20to%20generate%20data%20for%20appointments.%20So%20each%20excel%20row%20will%20have%202%20columns%3A%20date%20and%20time.%20Preferably%2C%20someone%20should%20enter%20the%20initial%20day%2C%20how%20many%20days%20and%20also%20initial%20time%20and%20time%20intervals%20and%20then%20the%20system%20should%20be%20able%20to%20populate%20data%20which%20will%20contain%20for%20each%20date%20all%20appointment%20times.%20Example%20like%20this%3A%3CBR%20%2F%3E%3CBR%20%2F%3E9%2F1%2F2021%208%3A00%3A00%3CBR%20%2F%3E9%2F1%2F2021%208%3A30%3A00%3CBR%20%2F%3E9%2F1%2F2021%209%3A00%3A00%3CBR%20%2F%3E9%2F1%2F2021%209%3A30%3A00%3CBR%20%2F%3E9%2F1%2F2021%2010%3A00%3A00%3CBR%20%2F%3E9%2F1%2F2021%2010%3A30%3A00%3CBR%20%2F%3E9%2F2%2F2021%208%3A00%3A00%3CBR%20%2F%3E9%2F2%2F2021%208%3A30%3A00%3CBR%20%2F%3E9%2F2%2F2021%209%3A00%3A00%3CBR%20%2F%3E9%2F2%2F2021%209%3A30%3A00%3CBR%20%2F%3E9%2F2%2F2021%2010%3A00%3A00%3CBR%20%2F%3E9%2F2%2F2021%2010%3A30%3A00%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20for%20date%2Ftime%20sequence%20I%20know%20I%20have%20to%20use%20this%3A%20%3DSEQUENCE(B1%2C%201%2C%20B2%2C%20B3)%20and%20I%20also%20found%20a%20nice%20example%20here%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.ablebits.com%2Foffice-addins-blog%2F2020%2F08%2F26%2Fdate-sequence-excel-fill-date-series%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.ablebits.com%2Foffice-addins-blog%2F2020%2F08%2F26%2Fdate-sequence-excel-fill-date-series%2F%3C%2FA%3E%3C%2FP%3E%3CP%3Eif%20you%20check%20this%20area%3A%20%5BI%5DCreate%20a%20year%20sequence%20in%20Excel%5B%2FI%5D%20you%20will%20see%20that%20it%20does%20the%20same%20but%20for%20years.%20Instead%20of%20having%20one%20date%20and%20all%20times%20and%20then%20next%20date%20etc.%20it%20has%20the%20same%20with%20dates%20and%20years%20but%20I%20have%20difficulty%20adjusting%20this%20to%20what%20I%20need.%20Any%20help%20is%20much%20appreciated.%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2772556%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2772763%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20workday%20and%20sequence%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2772763%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1162932%22%20target%3D%22_blank%22%3E%40pm4698%3C%2FA%3E%26nbsp%3BPerhaps%20easiest%20if%20you%20combine%20date%20and%20time%20in%20one%20dynamic%20sequence%20for%20the%20available%20time%20slots%20for%20one%20day.%20In%20turn%2C%20you%20can%20then%20dynamically%20reference%20that%20sequence%20and%20add%201%20to%20create%20a%20similar%20sequence%20for%20the%20next%20day.%20See%20example%20in%20the%20attached%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

1 Reply

@pm4698 Perhaps easiest if you combine date and time in one dynamic sequence for the available time slots for one day. In turn, you can then dynamically reference that sequence and add 1 to create a similar sequence for the next day. See example in the attached workbook.