select top 1 reading,emp_start,emp_end from bin1_final order by date SELECT top 1 reading,(datediff(second,emp_start,emp_end)) as x, 3600 as y from bin1_final SELECT top 1 (reading/(datediff(second,emp_start,emp_end))*3600) as y from bin1_finalThe result looks like shown in attachment.