Sometimes it is necessary to generate time intervals in Excel to make sure that there are all of them. It is an easy and flexible way to do this by using the relatively new Excel function SEQUENCE.
Tag: LET function in Excel
Define and use variables in Excel formula by using LET function
You can use variables in the Excel formula, and you can do that by using the function LET. Alternatively, you can use Excel capabilities to define names, but the function LET allows you to store variables inside the formula. It might be easier to maintain that in the long run.