I have 5 million+ rows of appointment data (start/stop times) that I am looking to convert to 15 minute blocks to use for demand forecasting in scheduling.
Example:
Start time: 9:30
Stop time: 10:10
I am looking to populate columns 9:30-9:44, 9:45-9:59, 10:00-10:14 each with a one and the other 93 columns would have a zero for that particular row.
Thanks.
Solved! Go to Solution.