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]
CENTRE_ID FACULTY TOTAL MINS PER DAY 141 2411 60 141 2442 60 141 2567 170 141 2669 120
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
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)