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
Solved! Go to Solution.
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 : )
Thank you so much, it worked.
However, my data type is in "Date Time" format. is that what you mean ?
@atcodedog05
Thank you so much, it worked.
However, my data type is in "Date Time" format. is that what you mean ?
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 : )
it does help. thanks alot