I have this formula in a google sheet that rounds up to the nearest 15 minute increment in a duration.
Can someone help convert this so i can have appsheet enter the info?
Basically, I am trying to eliminate all formulas in the sheet that appsheet uses.
Hereโs what Iโm using now:
=CEILING(P4,โ00:15โ),โ1:00โ)
Do you need to convert an existing value into a different column or do you want to write a validation rule for the input?
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:
=if(Q2>=1, CEILING(P2,โ00:15โ),โ1:00โ)
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.
If you want it as a decimal, something like this should give you thatโฆ =HOUR([END]-[START]) + (CEILING(MINUTE([END] - [START])/15.0)*15.0)/60.0
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |