Subtracting timestamps

[emperortekky]

Hi,

Can someone please tell me how I can add/ subtract timestamps and then converting the result to minutes/secs.

Just like in the attached. I will also like to know if this can be achieved also with live data. Thanks

[atcodedog05 · Accepted solution]

Hi @emperortekky 

Check out datetime diff functions in date-time functions

https://help.alteryx.com/20213/designer/datetime-functions

Minutes : Datetimediff([Time 1],[Time 2],"minutes")

Seconds : Datetimediff([Time 1],[Time 2],"seconds")

Hoping your dates are already in date format.

Hope this helps : )

[emperortekky]

Thank you so much, it worked.

However, my data type is in "Date Time" format. is that what you mean ?

[emperortekky]

@atcodedog05

Thank you so much, it worked.

However, my data type is in "Date Time" format. is that what you mean ?

[atcodedog05]

Hi @emperortekky 

If your data is in date type in excel it will be read in as date in Alteryx. Let's say the date in excel is not in date type and it not in format yyyy-mm-dd HH:MM:SS then we need to bring it to excel date type format yyyy-mm-dd HH:MM:SS.

Hope this helps : )

[emperortekky]

it does help. thanks alot