00:00I see in the video that we calculate the employee's overtime based on the number of overtime hours he worked on different days of the week.
00:09In this video we calculate some of the delays that the employee had.
00:15The employee is late by minutes on some days and late by hours on others.
00:20We calculate this accurately.
00:22And we start doing that
00:24First let's see the evidence we use.
00:27Then we start practically on the days we have.
00:31We have a timer that counts the minutes of delay for us.
00:35Just the minutes in the cell containing the time of attendance will give us an answer.
00:41When we know the number of minutes we start to do the calculation or total for the week.
00:48I will do the minutes of minutes
00:50We can know the status of the future and the anesthesia of the cell that contains the time of presence.
00:55We can know it by putting it in the minutes in the cell.
01:01Okay, I want to see each cell how many minutes it says about 8 o'clock.
01:07I will take the minutes
01:11Can you make the font bigger here so we can see?
01:21Control One
01:23I will make the font size 20 here
01:27okay
01:29And here I will start by merging the cells so that I show the minutes each day that are more than 8 hours
01:39This form
01:47Beautiful and strong
01:49I will start using the kettle every day separately to know the number of minutes of delays
01:53I will tell him that he is worthless
01:55I will open a bracket for him and choose the cells that contain the time and close the bracket and enter
02:01So you start saying that there are 30 minutes here
02:03I will pull the cells next to it so that I clearly know how many minutes of delay there are each day.
02:09So he started to say to me here for 30 minutes
02:11Here 20 minutes here 2 minutes and so on
02:13I started to know how many minutes this person was late.
02:17Ok, I want to know this group of minutes
02:19I think I will tell him that he is equal to Sam
02:23I have the minutes here
02:27Close the bow and enter
02:30Then you start telling me 62
02:32Ok, I want to know these minutes if they are correct
02:36How many hours will it take? I will divide this by 60.
02:40And he starts to bring me an hour and 3 out of 10, meaning he has
02:46Okay, that's great. These are my minutes. How do I calculate them?
02:51Ok, I have watches. I want to know the number of hours.
02:55This person is late here, a whole hour late
02:59So what do I do?
03:01I started using a coffee pot called awar coffee pot with an AF coffee pot.
03:05Let's first see how each coffee pot is used, one by one, to understand.
03:08Then we start applying it to our model or question.
03:12I started to use it as a kettle
03:15I will choose the cell that has my time and use it as Dallah Awar
03:20So, give me the time he came to work.
03:23Here he came at 8 o'clock Here he came at 8 o'clock No matter the minutes
03:28I started telling him that it is worth a lot
03:30I will open the cup and bring him this beehive, then close the cup and enter
03:35So you tell me that he is coming at 8 o'clock. Okay, that's very nice.
03:38I have a coffee pot called the FD coffee pot, a logical coffee pot.
03:42I started using it to test a certain condition.
03:45Can I tell him, for example, if the person here is older than 8?
03:49Start by writing me a specific word or doing a specific calculation for me.
03:53I use this as any silver cell that I want to show the result in.
03:57I tell him it's worth F
03:59Open the cup and tell him, for example, if there is more than 8 here
04:03Then I make my comma or semicolon
04:07Depending on the shape that appears to me in the cell
04:11When I make the coffee pot, the shape of the coffee pot appears below.
04:15If I find a semicolon, I use the semicolon.
04:17If I find a comma, I use a comma because this symbol differs from one device to another.
04:22If someone wants to write me a word that will appear,
04:25Write the word to him, clearly stating good, for example.
04:28I closed the quote and saw a tag to make the quote and I saw a tag to close it
04:33Then I'll do my parting for him again.
04:36value if false if the condition is greater than 8 is not met
04:40He will not take good
04:41So what will he get? I will write to him clearly stating bad, for example.
04:44I closed the double quotation mark and closed my cup and entered
04:48Five says he is bad
04:50Okay, if we want the word that appears to him
04:53I want to do a calculation
04:55I want to tell him if it is equal to
04:57Open cost
04:58I will tell him if the one here is older than 8
05:01Make me my comma or semicolon
05:05value if true
05:07I want him to start doing a certain calculation for me.
05:10I will write the mathematical operation for him, showing it in brackets, not in quotation marks.
05:12I saw 9 and opened the cost
05:14I saw 0, I opened the cost
05:16I will tell him to stay
05:19minus 8
05:21It appears to me that he attended for two extra hours.
05:24Attend three hours, whichever is better?
05:27I will lock the cost
05:29Then my semicolon value if false
05:32Can I write to him?
05:34Between quotation marks no
05:35For example, leave it empty
05:37As I like
05:39Here you will not find watches like this at eight o'clock
05:41So he started writing to me no
05:43If you changed this and made it another number, for example 7
05:49So, the number of hours will start here, which is 9.
05:51Here he starts to change the word for me
05:54Or he starts to say, excuse me, that he changed the quantity for me instead of it being no
05:57It will be 1
05:59So we know how to make a coffee pot
06:01To get a word or do a certain mathematical operation, and we know how to use the hour indicator
06:06Ok, how will I use this in my example or how will I use it in my model?
06:12I want to tell him to calculate for me the words that are here, if they are greater than 8
06:18If he comes after 8 o'clock
06:20Start by counting the hours of delay for me.
06:23I will leave it here for 9
06:25Let's see how we can calculate it together.
06:28I have an empty cell and I tell him it is equal to
06:31Oh, and open a parenthesis for him
06:33I want the clock here if it is bigger than 8
06:35It remains to be seen
06:37The time that this cell is in
06:40Close the bracket
06:42If it is greater than 8
06:44Then I will do my part for him
06:46Or my comma or semicolon
07:01The clock here is one hour minus eight
07:03So I know he's coming late in the morning
07:06How much?
07:07So do this math for me.
07:09And she closed her bow for him
07:10I make him my comma or semicolon
07:13Value of Fouls
07:14I will do it for him
07:15Formatting
07:16Clear
07:17And close the bow for him
07:18And you
07:19He starts by bringing me an employee who is an hour late for his scheduled time.
07:23Okay, just as I calculated the flour for each cell.
07:27I will start counting the hours of delay for him.
07:30I will start by merging the cells as well.
07:34So fast that I work the number of hours for all days of the week at once
07:43Just write my guide once
07:46And I started to make her a puller, and she kept repeating this to me.
07:50I'll start here and tell him it equals F.
07:53I will open the cup
07:56I will tell him that if what is here is more than eight, then what is here is an hour
08:03So I will start writing to him Hour if the time is here
08:06Greater than eight, make me a comma or my semicolon so we can write the value that will bloom
08:14The value that will bloom is a mathematical operation, so it is Hour.
08:18Between cups
08:20Hour for me who is here too
08:22The clock shows 9 o'clock to me, so it's 9 o'clock
08:26Minus eight
08:28And I will close the box of the mathematical operation for him
08:30Then I will start to make my comma or semicolon for him.
08:33Value if false
08:35I will coordinate it without any office stuff in it because I don't want anything to appear here
08:39And the cup was locked by Winter
08:41He starts telling me I'm an hour late here.
08:43Ok, I will see the rest of the other days
08:45He started to be late the next day by an hour
08:51And so on
08:53Calculate the total delay by adding the number of minutes plus the number of hours.
08:57I will start working a lot
08:59I will start by telling him that he is equal to me
09:00sum
09:03did not
09:04watches
09:06And the cup of work is closed with
09:09Visited
09:10I will start calculating the exact number for him by sixty.
09:14I will start by doing what is between brackets
09:16sum
09:18For flour
09:23I will close the operation cup
09:25Then I'll tell him on 60
09:28I will start using the name in it
09:32So I entered it, it looks good
09:34I can do it and you can do it.
09:36I will do the set of hours that are late
09:39With 3 minutes to go, stop number 10
09:43I will do it for you in the place for delays
09:46We understand, so we apply it practically.
09:49I will make you time the group of hours that are late
09:53The hour will remain the second article
10:00plus
10:03I will do what is between the brackets again
10:06If the total is for minutes
10:14I will close Sam's cup and swear by sixty
10:17Close the jar of the second mathematical operation and enter
10:20So, three appeared for me. If I want to see the decimal numbers that appeared for me
10:23I want to add, for example, two numbers, twenty, so that each one appears to me like this:
10:28So I simply started counting the minutes and hours.
10:33Regarding the employee's delay this week
10:36Come on, try it
10:37Try
Comments