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.