Post
Ask Question
Abhilash J A

Abhilash J A

  • 534
  • 2.4k
  • 597.2k

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?  

Answers (2)