AnsweredAssumed Answered

Creating a delimited set of time intervals

Question asked by dsimonson on Nov 6, 2014
Latest reply on Nov 6, 2014 by dsimonson


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