حساب عدد الساعات الإضافية في العمل في الاكسيل المحاسبي

Shereen Elmasry

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

Transcript

00:00In the previous video, we learned how to calculate the time difference between the departure and arrival times.

00:05We were able to know how many hours the employee was present each day.

00:09As is clear to us, he was attending a different number of hours every day.

00:14If I want to calculate the overtime of this employee

00:18I start by calculating the number of hours that the employee is supposed to work.

00:25Then I start to know how many extra hours he worked.

00:29Okay, the number of virtual hours. Let's say, for example, that it is 8 hours a day.

00:33The week has seven days and here there are two days off

00:36So I start by assuming that the default number of hours is 5, of which 8, I give it 40.

00:41This means that this employee is supposed to attend 40 hours per week.

00:45Ok, let's see how many hours he'll be here

00:47I will say it is equal to Samar

00:49I opened a cup for him and started counting the number of hours he attended daily.

00:54Lock the cup and enter

00:56So she starts to bring me 52

00:58Ok, 52 is supposed to attend only 40 hours.

01:03So he prepared 12 additional hours.

01:06I will start by calculating how this talk is valid.

01:08I will say it equals 40 minus

01:10The total is Samar

01:12I will open a cup for him

01:14I will tell him all the words that are here

01:17Lock the cup and enter

01:19And you

01:20So it starts to show me the result as a negative number because it is higher than the number I subtracted from it.

01:26We want to show an existing number, so I will start by clicking on it again.

01:29And I say it is negative one in

01:34Who saw eight keys in his soul?

01:37I will open a box and put all the good words in it

01:40And you

01:42So he starts to get the correct number, 12.

01:45Okay, it would be great if I could calculate this here in the extra box.

01:49I'll start saying it equals negative one.

01:51I will put it in the table so that it appears correctly.

01:54in

01:55I start by opening a cup for him

01:58Forty minus the sum of what is Sam

02:02And open for him the cup of the one you call

02:04I will bring all the attendance numbers.

02:07Close the cup

02:09And close the party cup, which is forty minus the total of these words

02:13And you

02:14So here it starts, it gives me 11.6 out of 10.

02:17If I don't want this decimal number

02:19Is it possible for me to format the data in this cell so that there are no decimal numbers?

02:24But I leave it with decimal numbers, there is no problem here

02:28So that it starts to show me the accounts accurately

02:31Come on, come closer

Category

Transcript

Recommended