How to calculate the total hours worked by employee per day?

Abhilash J A

10y1.1kSQL

Hello Everyone,

How to calculate the hours worked by all employees in a day using Sql query.

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

Thanks Advance,

Abhilash

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhilash J A10y ago
There is Input/Output Status (IOStatus) that is Entry and Exit that indicating I/O time with respect to status on IODate
0
Bhuvan Pandey10y ago
For calculate total hour, it is requiredtwo values - in time and out time.
Where isout time?
0
Vinay Singh10y ago
Hi
Where out time
0
Amitesh Verma10y ago
use sql datediff function,
You can first find the min time of the entry of a employee and max time of the exit of the employee. After that apply this datediff.
0