Difference in Time and Date

[rohit782192]

Hello Team,

How can we do a Difference in date in different row.

04:02:18

04:05:56

04:06:43

04:07:30

[binuacs]

@rohit782192 One way of doing this with the Multi-Row formula. First you need to append the time to any dates then using the DateTimeDiff function you can calculate the time difference

[Adrian_T]

Hey @rohit782192,

@binuacs's solution should would perfectly for you. Just thought to share this extremely useful link to DateTime Functions in Alteryx which should serve as a great reference whenever you find yourself needing to manipulate DateTime data types in Alteryx 🙂

https://help.alteryx.com/20221/designer/datetime-functions