Challenge #10: Date Time Calculations

[lucaskro]

Spoiler

[kaitlinDS37]

Spoiler

[katejoyce87]

:)

[FMODACK]

My solution.

[SaraHamdoun]

Spoiler

Here's my solution:

[matthewblandford]

Use of the Mod function makes this a one-tool solution!

[tothd]

ok

[boglarkalipka]

solved

[zorecchi]

A couple of points from this exercise. I'm not sure why the DateTimeFormat function was used in the solution; both TimeDate columns provided are in formats recognized by Alteryx. I now understand the MOD function that was used in the solution (mod = "remainder"), but this doesn't seem like the most intuitive way of approaching this problem. I instead used the FLOOR function (similar to ROUNDDOWN in excel). I provided two solutions in the attached workflow; one similar to the provided solution and one using the Floor function instead.

[nbilal]

Here's my solution using a single formula tool with a bunch of DateTimeDiff function calls.