Mani Kandan

Mani Kandan

  • 718
  • 2.3k
  • 405.7k

How to calculate the hours worked by all employees in a day?

Aug 20 2016 12:04 PM
Hello Everyone,
 
 How to calculate the hours worked by all employees in a day using Sql query.
 

EmployeeId

LoginTime

LogOutTime

1

2016-02-20 10:31:00.503

2016-02-20 13:00:00.503

1

2016-02-20 15:31:02.503

2016-02-20 19:00:02.503

2

2016-02-20 10:00:02.503

2016-02-20 18:31:02.503

 
From this table how can I calculate total hour per day by an employee?  

Brought to you by:

Answers (2)