Finding the time elapsed between two times

[Brytsyt]

Could someone please, if possible, assist me in creating a workflow that shows the difference between the 'Created Date (UTC)' and 'Last Modified Date (UTC)' in the attached sheet.

As they are on the same day I would like the output to ignore the date and just show the time elapsed between the two figures in a new column(D).

[ChrisTX]

Look at the DateTimeParse and DateTimeDiff functions

https://help.alteryx.com/current/Reference/Functions.htm

[Thableaus]

Hi @Brytsyt 

If you want the difference in seconds, here's a way to do it.

Use a Formula Tool:

DateTimeDiff(DateTimeParse([Last Modified Date (UTC)],"%m/%d/%Y %H:%M"),
Replace(ReplaceChar([Created Date (UTC)], "T", " "), "Z", ""), "seconds")

Cheers,

[mceleavey · Accepted solution]

Hi @Brytsyt ,

I've attached the workflow for you.

I've created the formula so it will tell you if the difference is in Days or Minutes.

I hope this helps.

M.

[Brytsyt]

Thank you @mceleavey that works perfectly!!

[Brytsyt]

Thank you for your help @Thableaus - much appreciated!!

[mceleavey]

No problem, @Thableaus .

Glad I could help.