floor and ceil date time more than 24 hrs

[Newbie_1]

Please find the attached workflow given by @jdunkerley79 in https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Time-Rounding/m-p/37037/highlight/fals....

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!

[BenMoss]

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.

Ben

[danrh]

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

Floor:

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

Ceiling:

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

Hope it helps!