AnsweredAssumed Answered

Help with setting a time to the nearest 15 minutes

Question asked by dsimonson on Jun 12, 2018
Latest reply on Jun 15, 2018 by fmpdude

Ok, my brain is breaking on this one.  I have a graph for our anesthetic record app that shows time as the x axis and vital signs (BP, pulse, etc) on the Y axis.

 

I would like to have the minimum of the Y axis to be the closest fifteen minute period to the anesthesia start time.  Like this:

 

Anesthesia start time is:

8:00: to 8:14 - set minimum of X axis to 8:00

8:15 to 8:29 - set minimum of X axis to 8:15

8:30 to 8:44 - set minimum of X axis to 8:30

8:45 to 9:00 - set minimum of X axis to 8:45

 

My thoughts were to do something like MOD(AnesthesiaStartTime;15), but I kind of got lost after that... Any help much appreciated.

Outcomes