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.
LinkedIn
Twitter
