# formula calculate overtime and delaying to worker for month

#### abdelfattah

##### Well-known Member
=hello
Sheet Axel is designed to come and leave workers for days of the month and workers

Sheet excel The most important point is to calculate the number of overtime and the number of delay hours for each worker throughout the month

At the end of the sheet there are two boxes

The first digit is the calculation of overtime is d3 : how the equation is made, knowing that the official exit time is 6.00 pm

And also the second square: the number of hours of delay is d2 throughout the month, knowing that the start of work is 7.30 am

Knowing also: Friday and Saturday are vacation

Is there a specific way in which I can calculate the number of additional hours and delay during the month?

Taking into account in the case of an employee leaving before the work date

the result bq9 ,br9
bq 9= total column (dissmis)
br 9= total column (presentce)

I wish I could find a solution to this problem, and I would be grateful to you

شيت حضور وانصراف.xlsx
1
2start time7:30 PM
3end time6:00 PM
4
5
6SATSUNMONTUEWEDTHUFRISATSUNMONTUEWEDTHUFRISATSUNMONTUEWEDTHUFRISATSUNMONTUEWEDTHUFRISATSUNMONTUEWED
7itemname05/25/202005/26/202005/27/202005/28/202005/29/202005/30/202005/31/202006/01/202006/02/202006/03/202006/04/202006/05/202006/06/202006/07/202006/08/202006/09/202006/10/202006/11/202006/12/202006/13/202006/14/202006/15/202006/16/202006/17/202006/18/202006/19/202006/20/202006/21/202006/22/202006/23/202006/24/202006/25/202006/26/2020OVERTIMEDELAYING
8PRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMISPRESENTCEDISSMIS
91JOHN--8:30 AM7:30 PM7:30 AM5:30 PM8:30 AM7:30 PM9:30 AM6:00 PM7:30 AM6:00 AM----8:30 AM7:30 PM7:30 AM5:30 PM8:30 AM7:30 PM9:30 AM6:00 PM7:30 AM6:00 AM8:30 AM7:30 PM7:30 AM5:30 PM8:30 AM7:30 PM9:30 AM6:00 PM7:30 AM6:00 AM8:30 AM7:30 PM7:30 AM5:30 PM8:30 AM7:30 PM9:30 AM6:00 PM7:30 AM6:00 AM8:30 AM7:30 PM7:30 AM5:30 PM8:30 AM7:30 PM9:30 AM6:00 PM
102SMITH
Sheet1

Last edited:

### Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

#### abdelfattah

##### Well-known Member
I would like to add information if the departure time in column (dissmis) is less than the legal time in d3 , then the difference is calculated as a delay and it is added to the delay in br9 (delaying).

up

anybody help

Replies
12
Views
478
Replies
3
Views
4K