Hi,
You can try below code also...
DECLARE @END_TIME VARCHAR(50)
SET @END_TIME = '09/06/2013 05:07:02 PM'
SELECT SUBSTRING(@END_TIME, CHARINDEX(' ',@END_TIME ,1)+1,20)
Let me know what logic you want to use to frame "00 hrs 01 mins 40 secs" to "1.4 mins or 1 min 40sec"
Regards,
GVPrabu