العمليات الحسابية البسيطة في الاكسيل - حساب فرق التوقيت - video Dailymotion

Shereen Elmasry

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

Transcript

00:00Once again we are back to complete the attendance and departure application together

00:04In the previous video, we learned how to merge cells and insert a new row.

00:09How do we know that we are doing the formatting or bringing up the formatting menu through the keyboard shortcut Ctrl+One?

00:17We also know how to get the employee's attendance and departure numbers.

00:22Now I want to calculate the time difference.

00:26Between the employee's departure and attendance, so that I know the employee daily

00:31How many hours did he stay at his job?

00:34What should I do?

00:35By default, we use simple functions to start calculating the time difference or the difference of anything.

00:43First, we understand how the currencies are calculated, then we calculate the difference in time.

00:48We have gone through the simple mathematical operations in the currency.

00:52We start by cleaning the cell in which we want the result to appear.

00:55We write to him equal to

00:57The number we want, or we click on the cell that contains the number

01:01I have a collector's operation that makes the mark yellow.

01:05The number I want

01:07Then Inter starts to bring me the result.

01:10It is possible that if I want to do a subtraction operation

01:13I want to tell him that the number is also equal to what I want.

01:16Or click on the cell

01:17The minus sign from the keyboard or menu

01:21Then the second number that I want to be presented

01:24I started pressing Enter and it brought me the result of the subtraction operation.

01:28If you want to make a feature, I will start making it for you here if there are any numbers so that you can try it with the cells as well.

01:35I will start telling him that it is equal to any existing number. This is the sign of the slash or the slanted line.

01:42Then I choose the number to divide by and press Enter to get the result of the division.

01:47If I want to do a stroke, I start by making an equal sign for it.

01:51Choose the first number after the multiplication sign, which is the star, from the keyboard.

01:56The second number and Inter starts giving me the life result

02:01If I want to do something, I ask power or secret, then I want Jack to do it.

02:07Fy power which is shIFT 6 from the keyboard and the second number and power

02:13And Inter Sarasa begins to 권 my hand that shows 요�Da number

02:17This is the simple process we do on Excel.

02:21Because I want the time difference

02:23Naturally I will use the arithmetic operation in which subtraction occurs

02:28I will teach all cells

02:31There will be a time difference.

02:33I will press 1 from the keyboard

02:35I will make it number

02:37I will make the decimal points travel

02:40Because there are no decimals.

02:42I will do the oil

02:44I'll make it time difference.

02:46The calculation will start with the difference between the two.

02:49I will do 24 hours

02:51Because the day is divided into 24 hours

02:59I will do 24 hour oil

03:02I'll make it 20 bp

03:06So it doesn't have to be a decimal number.

03:08I want an 8 hour difference between them.

03:11So to make it appear to me that it is a correct number, I will start by multiplying it by 24.

03:16We take care when I do a calculation that involves more than one thing. I start by putting what is between the best

03:22That means I want the result that comes out to me from subtraction to be the one that is multiplied by 24.

03:27So, in order not to confuse Excel, I will start by telling it to equal

03:30I will open a cup for him and tell him what is missing here

03:34Who is here and I will close the cup

03:36After he does this mathematical operation, he multiplies the result by 24 to get an integer.

03:43So I pressed Shift 8 on the keyboard to get the multiplication sign.

03:47She hit him with 24 and then

03:50Then she starts telling me that the employee or employer spent 319 hours at work in 8 days.

03:57Ok, as for me, the remaining days I will start to withdraw

04:00I will stand here on the cell from below

04:03Minus north is the opposite direction of my table or my gray hair

04:07And pull to the side

04:10North

04:11It starts doing the math for all the remaining cells.

04:15You start telling me that I worked here for 10 hours

04:19Here is 12 hours and here is 13 hours

04:21Here I come back again 8 hours

04:23Then I worked for 10 hours.

04:26And then it took 12 hours

04:28Ok, I notice that I am here when

04:30I came to the next cell

04:32She started to calculate the difference for me

04:34between

04:36E4 and D4

04:38Here I calculated the difference between

04:40G4 and F4

04:42It means that it starts automatically to increase one

04:44On the cell number so that

04:46Calculate the next cell for me

04:48We know in this video

04:50simple arithmetic operation

04:52In Excel

04:53We know that we envy the time difference

04:55And the first thing we change

04:57Cell coordination

04:59Let's leave it as a number

05:00We will remove the decimal numbers.

05:02If we don't want decimal numbers

05:04I will start

05:06Do the subtraction operation between cups.

05:08And the result is calculated in 24

05:10So that it appears to me with the correct number

05:12Not broken

05:14We fall in love

العمليات الحسابية البسيطة في الاكسيل - حساب فرق التوقيت

Category

Transcript

Recommended