SOLVED
How to get Date, hours and minutes difference
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Belletmns
8 - Asteroid
‎10-23-2020
12:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
What formula should I use to get the date, hours and minutes difference in Alteryx?
Duration should appear like this:
Thanks in advance!
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
3 REPLIES 3
grazitti_sapna
17 - Castor
‎10-23-2020
12:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Belletmns , could you provide some data with sample output?
I have prepared a mock workflow, just need to validate it.
Thanks.
Sapna Gupta
16 - Nebula
‎10-23-2020
12:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎10-23-2020
01:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It works! Thank you so much
