Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to get Date, hours and minutes difference

Belletmns
8 - Asteroid

Hi All,

 

What formula should I use to get the date, hours and minutes difference in Alteryx?

 

Belletmns_0-1603437853723.png

 

Duration should appear like this:

Belletmns_1-1603437889718.png

 

Thanks in advance!

3 REPLIES 3
grazitti_sapna
17 - Castor

Hi @Belletmns , could you provide some data with sample output?

I have prepared a mock workflow, just need to validate it.

 

grazitti_sapna_0-1603441106198.png

 

 

Thanks.

Sapna Gupta
RolandSchubert
16 - Nebula
16 - Nebula

Hi @Belletmns ,

 

it needs a bit of DateTime calculation.

 

I've attached a sample workflow. Let me know if it works for you.

 

Best,

 

Roland

Belletmns
8 - Asteroid

It works! Thank you so much

Labels
Top Solution Authors