Kind of an existing value… I have a start time column, an end time column, and another column that calc’s the duration.
From the duration, another column is calc’d from the duration to decimal.
I need the duration, rounding to the nearest 15 min interval, perhaps on the fly, but it has it’s own column.
Also, the original formula posted wasn’t in full, and probably caused confusion.
The end of it is an else statement.
Here’s the whole formula:
See attached a screenshot which probably makes more sense than I’m writing.
I do have the P column in the pic coming from virtual columns breaking down hours, minutes, and seconds…so perhaps I can pluck that formula from there.