Convert TIMESPENTONREQ

Hello,

My ultimate goal is to get the difference of CREATEDTIME and COMPLETEDTIME into format of:

DD:HH:MM. I tried the following, but results are incorrect.

convert(varchar(10),((wo.COMPLETEDTIME)-(wo.createdtime))/86400)+' Days '+
convert(varchar(10),(((wo.COMPLETEDTIME)-(wo.createdtime))/1000)/3600)+' Hrs '+
convert(varchar(10),(((wo.COMPLETEDTIME)-(wo.createdtime))/1000)%3600/60)+' Mins'"Time Elapsed",

I tried using TIMESPENTONREQ, but it returns incorrect results. I followed the instructions below, but cannot figure out how to get "Days".

https://pitstop.manageengine.com/portal/community/topic/convert-timespentonreq-field-in-sql

MS-SQL

10.5 Build 10503

Thanks in advance,

Jim