Use
MSDN: DATEDIFF (Transact-SQL)[
^] to find the time difference between InTime & OutTime.
Put something like this query in stored procedure.
For a given employeeId:
SELECT
EmpName,
DATEDIFF(hour, Intime, Outtime) as HourTime
FROM
Employees
WHERE
Empno = @EmployeeNo