Overtime

[aliikhlaq2006]

I have query that is based on the in and out time of employees. I want to calculate the overtime of the employee by subtracting the out time with in time and if the result is more than the standard hours than shows the extra time as result

 

[isladogs]

What is the standard working day?
What format do you want for the extra time result?

Please post a screenshot with a few sample results

 

[aliikhlaq2006]

What is the standard working day?
What format do you want for the extra time result?

Please post a screenshot with a few sample results

i have attached a required screenshot

 

[isladogs]

See attached for one possible solution.
I've used functions to make it more easily usable on other databases

There are other ways of doing the same thing

NOTE:
1. I've removed spaces in field names
2, I've changed TimeIn & TimeOut to DateTimeIn & DateTimeOut to manage issues with staff who work through midnight e.g. Faraz
3. I've also allowed for staff working part hours

 

[aliikhlaq2006]

See attached for one possible solution.
I've used functions to make it more easily usable on other databases

There are other ways of doing the same thing

NOTE:
1. I've removed spaces in field names
2, I've changed TimeIn & TimeOut to DateTimeIn & DateTimeOut to manage issues with staff who work through midnight e.g. Faraz
3. I've also allowed for staff working part hours

it work for me thank you i need some more help in same. i want to set the parameter what is the total overtime hours in a specific month for each employee.
i tried through group by but its give error and as on last month the 2nd shift will have time in next day how i will manage this in parameter

 

[jdraw]

Look at some of the posts/links to related or similar posts at the bottom of the page