Overtime (1 Viewer)

A

aliikhlaq2006

Registered User.
Local time
Today, 18:48
Joined
Aug 10, 2017
Messages
17
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

isladogs

MVP / VIP
Local time
Today, 15:48
Joined
Jan 14, 2017
Messages
18,216
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
 
A

aliikhlaq2006

Registered User.
Local time
Today, 18:48
Joined
Aug 10, 2017
Messages
17
ridders said:
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
Click to expand...

i have attached a required screenshot
 

Attachments

  • Capture.PNG
    Capture.PNG
    12.5 KB · Views: 92
isladogs

isladogs

MVP / VIP
Local time
Today, 15:48
Joined
Jan 14, 2017
Messages
18,216
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

 

Attachments

  • WorkHours.PNG
    WorkHours.PNG
    12.8 KB · Views: 126
  • Overtime.zip
    23.2 KB · Views: 79
A

aliikhlaq2006

Registered User.
Local time
Today, 18:48
Joined
Aug 10, 2017
Messages
17
ridders said:
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

Click to expand...
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

jdraw

Super Moderator
Staff member
Local time
Today, 10:48
Joined
Jan 23, 2006
Messages
15,379
Look at some of the posts/links to related or similar posts at the bottom of the page
 
You must log in or register to reply here.

Similar threads

B
Overtime Formula
Replies
3
Views
451
BowDan
B
K
Solved I need help converting overtime hours to the round figure.
Replies
6
Views
516
Khurramshaikh47
K
N
SQL Views Syntax any simple way
Replies
10
Views
345
Minty
Minty
H
Overtime worksheet
Replies
4
Views
480
Hawkins1989
H
C
Query to include "X Criteria", but not exclude other criteria in same field associated with Employee
2
Replies
21
Views
760
Pat Hartman
P

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom