Derive a column value based on other on same row

See more:

ASP.NET

SQL-Server

DateTime

I have gt a SQL Query

SELECT
   [CENTRE_ID]
  , [FACULTY]
  ,SUM(CONVERT(INT ,ABS(DATEDIFF( MINUTE,CONVERT(TIME,[STARTTIME]),CONVERT(TIME,[ENDTIME]))))) AS 'TOTAL MINS PER DAY'
FROM [MISONLINE_NEW].[dbo].[BATCH_MASTER]

WHERE BATCH_STATUS LIKE 'P'
AND [STARTTIME] NOT LIKE 'ND'
GROUP BY [FACULTY], [CENTRE_ID]

, this returns all those records that matches the where clause.

Here are few records of the returned result set

CENTRE_ID    FACULTY    TOTAL MINS PER DAY
     141         2411              60
     141         2442              60
     141         2567             170
     141         2669             120

I want a fourth column that can be generated based on TOTAL MINS PER DAY that converts Minutes into hours and Minutes

CENTRE_ID	 FACULTY    TOTAL MINS PER DAY	    TOTAL HRS PER DAY
      141         2411	            60	              1hr
      141	  2442	            60	              1hr
      141	  2567	           170	              1 hr 50 mins
      141	  2669	           120	              2 hrs