Round seconds to minutes

[aortegaher87]

Hi, 

I wanted to see if it possible to round seconds to minutes. For example:

13:23:39 --> 13:24:00

16:48:11 --> 16:48:00

The threshold is 29 seconds or below will round down to the actual minute and 30 seconds and above will round up to the next minute.

Thanks!

[JagdeeshN]

@aortegaher87 

Please check the below discussion on a similar topic.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Time-Rounding/td-p/37023

The replies to this post contain some solutions that you can possibly use.

Do let me know if this helped.

Best,

Jagdeesh

[danilang]

Hi @aortegaher87 

Here's a different method from those in https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Time-Rounding/td-p/37023.

if DateTimeSeconds([TimeStamp])<=29 then
	DateTimeTrim([TimeStamp],"minutes")
else
	DateTimeTrim(DateTimeAdd([TimeStamp],1,"minutes"),"minutes")
endif

If seconds <= 29 trim the timestamp to the minute, else add one minute and trim the result

Dan

[MarqueeCrew]

@danilang ,

 if the incoming data is purely time, you would need to modify the formula by adding a fixed date to it. 

cheers,

 mark