Is there a better way to get the hour information, or is this the most optimized mode, please need help CASE WHEN DATEPART(Hour, StartDTM) = 1 THEN CASE WHEN DATEPART(Hour, EndDTM) = 1 THEN CAST(DATEPART(minute, EndDTM) - DATEPART(minute, StartDTM) AS FLOAT)/60 ELSE CAST(60 - DATEPART(minute, StartDTM) AS FLOAT)/60 END WHEN DATEPART(Hour, EndDTM) = 1 THEN CAST(DATEPART(minute, EndDTM) AS FLOAT)/60 WHEN 1 BETWEEN DATEPART(Hour, StartDTM) AND DATEPART(Hour, EndDTM) THEN 1 ELSE 0 END AS '1AM',
Thank you very much for the helpful info.