SELECT CAST((DATEDIFF(dd,0,dateval) *24 + DATEPART(hh,dateval)) AS varchar(3)) + ':' + DATENAME(minute,dateval)
FROM (SELECT DATEADD(minutes,yourfield,0) AS dateval FROM table)t

Visakh - since our discussion on some other thread last week about datetime functions wrt allowing any indexes to still be used, you have converted me to use these datetime calculations as much as possible as opposed to MONTH and Year type functions.

I had never given this side of sql any thought until you pointed this out to me. Thanks again.

Visakh - since our discussion on some other thread last week about datetime functions wrt allowing any indexes to still be used, you have converted me to use these datetime calculations as much as possible as opposed to MONTH and Year type functions.

I had never given this side of sql any thought until you pointed this out to me. Thanks again.