calculate of total working time of an employee

calculate of total working time of an employee in a day

suppose the time in is mentioned in column b3 and time out in column c3 and the total has to be displayed in d3.

and one more problem
how to calculate the leaves of an employee

say date of 1st leave is mentioned in b4 and last leave in c4 and the result to be displayed in d4 and main issue say the employee has taken leave only for 1 day , then the total leaves that is in d4 it is to be displayed as 1.

please help me and it will be great help if anyone can mail the solution to my personal email-id.

Kanwal Deep Singh
[email protected]