I have clock times that a person entered a building with. I also have a field called Rounding, which sets a 0 fro false and 1 for true if we allow rounding or not. There is another field called Rounding_Hours, which is a decimal field that requires a value for the amount of time we want to round by. For instance, to round to the nearest 15 minutes, we set the value to be 0.25.
I want to round the clock times by the value set, but I need help doing so. My code looks like this:
Calc_work_start_time = case when StartRounding_Up = 1 then ** do something ** end