Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

floor and ceil date time more than 24 hrs

7 - Meteor

Please find the attached workflow given by @jdunkerley79 in

I have 2 different datetime columns for which i need to perform 10 mins round off with floor and ceil option. How can i incorporate that into the attached workflow?


Thanks in advance!


Alteryx Certified Partner
Alteryx Certified Partner

Hi Newbie,


To me it's not quite clear what you are looking for. Could you please provide some example input data and what your desired output from that data would look like.



13 - Pulsar


In the first Formula tool, change Minutes + 60 * Hours to one of the following:



FLOOR((Minutes + 60 * Hours)/10)*10


CEIL((Minutes + 60 * Hours)/10)*10

Hope it helps!