Finding the time elapsed between two times

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).

Processing Time.xlsx

Date Time

Accepted answers

mceleavey

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.

workflow.yxmd

All comments

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

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.

workflow.yxmd

Brytsyt

Thank you @mceleavey that works perfectly!!

Brytsyt

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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335