حساب التأخيرات باستخدام الدوال في الاكسيل المحاسبي

Shereen Elmasry

يحتوي الكورس على مجموعة مميزة ومختصرة من الشروحات المعدة بشكل دقيق لتناسب كافة احتياجات العمل والدراسة حيث يتناول بالشرح استخدام الأدوات والدوال المختلفة مع توظيفها في نفس الوقت في مشاريع عملية مختلفة ليستفاد الدارس أقصى استفادة وكأنه قام بدراسة عدة كورسات اكسيل في نفس الوقت من خلال كورس واحد يضم (الاستخدام العام لبرنامج الاكسيل - الاكسيل المحاسبي - شرح الدوال والعديد من الأساليب المتقدمة في الاكسيل)

Transcript

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

Category

Transcript

Recommended