Converting seconds to yyyy/MM/dd HH:MM:SS for more than 24 hours

[nilima]

I am trying to convert seconds to HH:MM:SS for more than 24 hours time duration. I have another column which has date in it. By combining both timestamp and date, I am creating a DateTime field in format (yyyy/MM/dd HH:MM:SS). However, it is converting seconds more than 24 hours to 24:00:01 which is not a valid time stamp. 

I would like to attain something like this from seconds and Date field.

Any help in this regard is highly appreciated.

[JosephSerpis · Accepted solution]

Hi @nilima I mocked up a workflow it produces the output you ask for but also provides in a format alteryx recognises  as a valid date format which is yyyy-MM-dd HH:MM:SS. Let me know what you think?