What will be the expression for diff of time between 2 columns. I have Datein & Date out columns and i would need to find the difference in time hh:mm:ss for every row. This is my format : 6/30/2010 1:33:30 PM FM

You can obtain the difference between two dates in, say, seconds using following SQL Server function: DATEDIFF ( s , startdate , enddate ). Is that what you want?Remember to mark as an answer if this post has helped you.

yeah thats what i wantFM

yeah thats what i want FM Then you'll use the : DATEDIFF ( s , startdate , enddate ). As he said above in your SQL Query.