It is a SSIS developer snack. Today on the MSDN Forums I came across a post in which a person asked for help converting an arbitrary number seconds to HH:MM:SS format.
I quickly reached out to my SSIS Expression Editor and Tester where I store any helpful SSIS expressions I developed or came across.
After posting my reply back I decided to share it online, so without further ado it is:
RIGHT("000" + (DT_WSTR,3)(@[User::TimeInSeconds] / 3600),3) + ":" + RIGHT("00" + (DT_WSTR,2)((@[User::TimeInSeconds] % 3600) / 60),2) + ":" + RIGHT("00" + (DT_WSTR,2)(@[User::TimeInSeconds]% 60),2)
Enjoy when handy!