Try this
DECLARE @Dt AS DATETIME
SELECT @Dt= CAST('13:30:00' AS DATETIME)-CAST('09:00' AS DATETIME)
SELECT CAST(((DATEPART(HOUR,@Dt)*60)+DATEPART(MINUTE,@Dt)) AS VARCHAR)+' Minutes'
Result:
<pre lang="text">270 Minutes
Update:
It's better to use following
DECLARE @Dt DATETIME
SET @Dt = '01-01-2001 07:10:20'SELECT @Dt= CAST('13:30:00' AS DATETIME)-CAST('09:00' AS DATETIME)
SELECT CAST(DATEDIFF(MINUTE, DATEADD(DAY, DATEDIFF(DAY, 0, @Dt), 0), @Dt) AS VARCHAR)+' Minutes'
Hope, it helps :)