2 Replies Latest reply on Nov 6, 2014 4:24 PM by dsimonson

    Creating a delimited set of time intervals



      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