30 minutes time increment round up

SUNNY_BUNNY

Hi, I'm trying to create a column in Smartsheet that shows 30 minutes increment round up. I have a column that shows in minutes for the differences of the start time and end time.

=(TIME([end]@row)-TIME([start]@row))*24*60
How can I use ROUND to use in this case for 00:30 increment?

Thank you in advance!

NicoLHC

Hello @SUNNY_BUNNY ,

how about this =ROUNDUP(((TIME(end@row) - TIME(start@row)) * 24 * 60) / 30, 0) * 30

NicoLHC

Hello @SUNNY_BUNNY ,

how about this =ROUNDUP(((TIME(end@row) - TIME(start@row)) * 24 * 60) / 30, 0) * 30

SUNNY_BUNNY

Thank you! it worked as expected.