00:00In this video, we learned how to calculate employee delays.
00:06In this video we start calculating the employee's absence days during the week.
00:14We will use the country count f to calculate the number of days the employee is absent.
00:22We don't use the country count if because we are actually living life
00:29We start in spite of the employee's absence during the employee's absence he must
00:39Reduce employee absences during the week
00:43We commit employee absence so I use the state of the account if for the pain
00:49I tell him that count F equals count F, meaning it passes me the cell if it contains a specific condition. Here, count F is an open cos
00:59I will start by defining the range that I want, then I will make it my comma or semicolon.
01:05Criteria condition: What can I tell it to be the value in this cell and press enter to close it, and it will start telling me one?
01:14Here, if I remove the word absent, it will start telling me 0, meaning it is passing by. But what are the things that I want?
01:21I want to modify the word absent, so I will modify the word absent. If I want to modify a word, for example, great, I will modify the word great, and so on.
01:29Okay, you will apply this practically to my model. If on the day the person is absent, there will be no attendance or departure.
01:37So I will start by recording his attendance and departure, for example:
01:44And I will write to him here where this part is absent
01:48So the person has been absent with me for a day
01:53I want to start by leaving his absence for the week. I will start by telling him here equals count F.
01:59I gave him a cup and started to set a time limit for him in terms of the number of hours.
02:09Then I give it my comma or semicolon and we go back to complete. I want to give this text. If it contains the word absent, then I will know the cell that contains absent.
02:20Or do it between the halves of the word absent with the same two letters.
02:24I will close the door on him and the person will be absent for one day
02:28Here I have the extra time coming out negative because it is the extra time
02:34He took it from me for a day, so I dealt with it negatively. I can just show you what the final shape will be. I don’t want this negative at all.
02:41I will start adding the hours here, for example, if he leaves today at nine o'clock
02:46So he shows up with me extra time
02:48So the first week will be counted for me. I will start now to do his coordination.
02:53I will start doing this within limits
02:58Here I make my own boundaries
03:00Okay
03:02Can I make a distinction for each day so that it is a different color from the other color?
03:09Here, for example, in this color
03:12Thursday and Saturday
03:14I start by pressing Control to mark a group of columns or more than one range. I start by coloring it at once.
03:24Like this
03:26And I start by teaching here the four
03:31Friday and Sunday
03:33I'm still pressing the control
03:38I will teach you the remaining parts
03:40So that it takes on a color, for example.
03:44Green
03:46Here is the part of the first week, which will have a distinctive color.
03:51Can I click on a turquoise color for it, for example, to make it stand out?
03:56And here I will start to give them color.
04:00For example
04:02So my first week is over, I will start copying and pasting it.
04:07Because it is impossible for me to do all the things you did in the first week for all the weeks
04:11Copy it
04:13Come here and make it paste
04:15Make sure the functions are downloaded correctly
04:19Here is cell 12
04:22G12
04:23I will start by inlaying the coffee pot if it has G12
04:27So the coffee pot is on me correctly
04:30But we must be careful not to paste from the beginning of the row.
04:36So I will start by pressing ctrl z and then I will go back to the beginning
04:40Paste ctrl v from the keyboard
04:43Make sure the kettle is on correctly
04:46And I start here again, I want to download the last week, the third week
04:53Here it is, the second week
05:00Of course, the days ended on Monday and we started on Tuesday, so this is normal.
05:05Here it remains for him history we were ending with seven nine remains here
05:10Eight nine and we start to withdraw as everything we have is accurate and correct
05:18We finished with 14 nine in the second week. Here we have 15 nine in the third week.
05:25Ok, and the 15th is the nine, so I'll start withdrawing it.
05:35We are Kabi again, the month is not over yet
05:40I will start by going down and doing it here
05:47This is the fourth week
05:51Here instead of 15 nine it will be 22 nine
06:02And we start to withdraw
06:0728 Nine is the last week, there will be fewer days, and we will start to do a different calculation. You will understand how.
06:17I will start again by pressing Ctrl+C on the keyboard
06:24And I start to go down
06:27Here is the control in
06:30And I start to make this the fifth week
06:33Here it should end with 28 nine. We will start with 29 nine.
06:41And I start to pull
06:46September is 30 days away, so I don't want to hear what's going on here.
06:54I will start by saying that I am completely empty
06:58Okay
06:59September, the fifth week or the last week, has two days, and both days are working days.
07:04I will start by making the average of the days of attendance
07:09Here it is supposed to be 16 hours and not 40 hours, if you remember the extra time we used in it.
07:15We will start by changing the number 40 to 16.
07:19And you
07:23He starts to think about me like this
07:25This is my month, I will start, I want to end it
07:32Calculate the number of days of delays, how many days of delays, how many absences, and how much overtime
07:38I will start using a bucket of poison for delays.
07:41To know his set of delays during the month
07:45And I start to define the column
07:47Of course, a pot of poison has nothing to do with us writing the lyrics.
07:50It will start to count normally as well.
07:53Here he has a 14-hour delay, thank God
07:57Here for absence equals cm
08:00I will count his absence
08:03I will close the door and enter
08:06He has been absent for 4 days
08:08And the extra is equal to cm
08:10I will start calculating the extra for him
08:13Lock the cup and enter
08:16He starts telling me he has 7 extra hours.
08:20So we have the attendance and departure form behind us.
08:23Come on, come closer
08:24Thanks
Comments