Round up/down time formula

Hi

So I have made an expression for a column called time with “Time” are format and using

TIME(
TIME(HOUR(NOW()-“0:00”)+“1:00”)-
IFS(
MINUTE(NOW()-“0:00”)>45,“0:00”,
MINUTE(NOW()-“0:00”)>30,“0:30”,
MINUTE(NOW()-“0:00”)>15,“0:30”,
MINUTE(NOW()-“0:00”)>0,“0:30”
)
)

I had to change the column to DateTime format and are not sure how to set up this expression for that.
Have tried replacing TIME with NOW but does not round up the time for me then.
Any help is appreciated.

Simon@1minManager.com

1 Like