Try:
SELECT DATENAME(DW,Dated) as Days, FinalTime
FROM [Attendance].[dbo].[AttnDaily]
WHERE EmpID=111 and Dated>='2015-09-14' and Dated<='2015-09-18'
UNION ALL
SELECT 'Total Hours' As Days, CONCAT(cast(sum(datediff(second,0,[FinalTime]))/3600 as varchar(12)), ':' ,
right('0' + cast(sum(datediff(second,0,[FinalTime]))/60%60 as varchar(2)),2) ,
':' , right('0' + cast(sum(datediff(second,0,[FinalTime]))%60 as varchar(2)),2)) AS FinalTime
FROM [Attendance].[dbo].[AttnDaily]
WHERE EmpID=111 and Dated>='2015-09-14' and Dated<='2015-09-18'
For further information, please, see:
UNION[
^]
CONCAT[
^]