Creating a delimited set of time intervals
In my solution, I would like to take an inputted "anesthesia start time", and then create a delimited set of 20 "times" that would start with the first 15 minute point prior to the start time and then fills in the other times. Example: The CRNA enters an anesthesia start time of 8:23 (I am using 24-hour times). The function would then create a set of 20 delimited times - 8:30, 8:45, 9:00, 9:15, and so on.
Once I create this delimited time series, I am going to use them to populate some fields that will then show up across the top of a grid that will be used to show the approximate times of medication administration and so on.
Ideas? I'm thinking of a "Let" function, and working on it, but I am getting a headache just thinking about it. Thanks.
Dan Simonson, CRNA, MHPA
2607 S. Manito Blvd.
Spokane, WA 99203
H. (509) 747-0819
C. (509) 981-6274