Days not exceeding 24, and Hrs not over 60 as well as Min not over 60

Cast(floor(column_name/1440) as char)||'days'||' '||cast(floor(mod(column_name,1440)/60) as char)||'hours'||' '||cast(mod(mod(column_name,1440),60) as char)||'minutes'

Until Next Post.... :)