Round seconds to minutes

Question

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!

MarqueeCrew · Answer

@danilang ,

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

cheers,

mark

danilang · Answer

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

JagdeeshN · Answer

@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