Rounding time values

Hi, is there a way to round up or down time values to the nearest 15 minutes?

Thanks

image

I found the following thread and hope it helps…

Example time rounding.pbix (38.8 KB)

1 Like

Thanks Yi. I tried creating a column and following the formula. However it is not recognises any of the command examples.

Sorted, thanks for the help. Its a excel command! :hot_face: The command that worked was,
MROUND( COLUMNNAME, TIME(0,15,0))