i want to calculate timespan between two columns

Question

i want to substract time(i.e. in_time and out_time) present in two columns of database table which is to be displayed in table format in the web page.....please suggest some sql query and c# code