InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 07:30:00 GMT20http://www.sqlservercentral.com/Forums/Topic1422299-391-1.aspxEven this would do the work for you and is probably much simpler[code="sql"]SELECT CONVERT(TIME, DATEADD(SECOND, DATEDIFF(SECOND, minibgtime, maxendtime), '' ) )FROM tablename[/code]Thu, 21 Feb 2013 00:33:11 GMTKingston Dhasianhttp://www.sqlservercentral.com/Forums/Topic1422299-391-1.aspxNever Mind i figured outselect (CONVERT(varchar(6), DATEDIFF(second, minibgtime, maxendtime)/3600) + ':' +RIGHT('0' + CONVERT(varchar(2), (DATEDIFF(second, minibgtime, maxendtime) % 3600) / 60), 2) + ':' +RIGHT('0' + CONVERT(varchar(2), DATEDIFF(second, minibgtime, maxendtime) % 60), 2)) as Total_Timefrom tablenameThankyou.--Sam.Wed, 20 Feb 2013 15:28:11 GMTsunder.mekalahttp://www.sqlservercentral.com/Forums/Topic1422299-391-1.aspxselect datediff (Mi,Cast((minibgtime) as datetime), Cast((maxendtime) as datetime))/60) as Total_Minutesfrom tablenameThe above Sql Query should give me 2:30:00 instead of 150 minutes, here i have make changes in the above query , just to clarify i have to make changes inthe above query itself.Thankyou.--Sam.Wed, 20 Feb 2013 15:09:36 GMTsunder.mekalahttp://www.sqlservercentral.com/Forums/Topic1422299-391-1.aspxadd those minutes to a date @ 00:00:00 hrs then format as a time. As an example:declare @mins intset @mins = 150select convert(char(5),dateadd(minute,@mins,'01/01/2013'),108)Wed, 20 Feb 2013 14:59:48 GMTsturnerhttp://www.sqlservercentral.com/Forums/Topic1422299-391-1.aspxHi,Here minibgtime and maxendtime are in below format 2013-02-19 16:15:48.000select datediff (Mi,Cast((minibgtime) as datetime), Cast((maxendtime) as datetime))/60) as Total_Minutesfrom tablenameNow i am getting something like a number 150 minutes but i want to see that as 2:30:00as 150 mins = two hrs 30 minutes.Any help is appreciated.Thanks,Sam.Wed, 20 Feb 2013 14:12:11 GMTsunder.mekala