Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Datetimeparse

Norhusain
6 - Meteoroid

Hi Everyone,

 

New here and just want to ask, using the data below how can we get a result in the form of (hh:mm:ss)

 

Calculate Time Difference

08:36:00 - 00:01:49 = 08:34:11

 

When using the DateTimeDiff(a,b,"seconds") then using datetimeparse to hopefully get the output I want its resulting to a NULL 

 

Thanks

2 REPLIES 2
binuacs
21 - Polaris

@Norhusain One way of doing this 

 

binuacs_1-1685134675271.png

 

 

 

 

Norhusain
6 - Meteoroid

Awesome!!!! Thank you so much

Labels
Top Solution Authors