Get Hours Only From SQL Server Date for Excel Report

SELECT

[USER_NAME]
, [rcvd_datetime]
,
right(CONVERT(varchar(13),[rcvd_datetime],120),2) +':00:00' as [Hours] ,[activity_name] FROM [Tablename] ORDER BY 2 ASC