didnt understand why you're storing date values like this in two different fields and also in this format. if you had used datetime fields manipulations would have been much easier.for current format its rather messy. here's a start for you to use in your queryDECLARE @SDate varchar(10),@STime varchar(10),@Edate varchar(10),@ETime varchar(10)SELECT @SDate ='20-01-2012',@STime ='07.00',@Edate ='22-01-2012',@ETime ='15.31'SELECT CONVERT(varchar(5),DATEDIFF(ss,CONVERT(datetime,@SDate+ ' ' + REPLACE(@STime,'.',':'),103),CONVERT(datetime,@Edate + ' ' + REPLACE(@ETime,'.',':'),103))/3600) + '.' +CONVERT(varchar(10),(DATEDIFF(ss,CONVERT(datetime,@SDate+ ' ' + REPLACE(@STime,'.',':'),103),CONVERT(datetime,@Edate + ' ' + REPLACE(@ETime,'.',':'),103))% 3600.0)/60.0)
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ 
How to sum time with counting??
Posted - 2012-01-16 : 08:15:42
[/URL]Uploaded with [URL=http://imageshack.us]ImageShack.us[/URL]Red word = branch 1blue word = branch 2So, branch 1 shipping stuff to branch 2, and this database trying to measure how much time to travel from branch 1 to branch 2.I am trying to make datawarehousing from this data.Thanks in advanced :)
[/URL]Uploaded with [URL=http://imageshack.us]ImageShack.us[/URL][URL=http://imageshack.us/photo/my-images/830/333333333333333333333y.png/]
[/URL]Uploaded with [URL=http://imageshack.us]ImageShack.us[/URL]thanks for replies 
============forgot to mentioneverytime taken from local time in each branch computer