Dicas e tutoriais de Cássius Tech Informática - Dailymotion

Cássius Tech Informática

Veja a lista de reprodução Dicas e tutoriais de Cássius Tech Informática no Dailymotion

Transcript

00:00Hello everyone, how are you? This is Cássios speaking, and welcome to another video on the Tec Informática channel.

00:10And today guys, I'm going to show you how to calculate the value per hour worked and also the value per day worked.

00:19Based on gross salary, okay? Through Excel, right?

00:26I'll work here with Excel to show you.

00:31And what will I need to know? I need to know how much the gross salary is

00:36I will use as an example the gross salary, without deducting INSS, without deducting VT, ticket, transport voucher

00:45Just the gross salary and I will also need to know the number of hours worked in the month, right?

00:54So I'm going to put it here in the gross salary, I'm going to put here a salary of R$1,518, right?

01:03And here in the hours in the month I'm going to put 220 hours here, okay?

01:09This is just an example, okay?

01:11It could be fewer hours, it could be for example 180 hours, it could be a slightly higher salary, a slightly lower salary

01:17But I'll use this one as an example, okay?

01:23So for me to know the hourly rate I need to know the gross salary first, not the salary I earn.

01:30And in this case here, the gross salary that I'm using as an example plus the hours of the month

01:38So I come here now, I put the equal sign, because I'm working with Excel

01:45Then I come and select the gross salary, which is here in cell E5, column E row 5, right?

01:56I'm going to divide, oops, I'm going to divide by the number of hours worked, which is 220, right?

02:08Which is cell F, right? Column F, row 5

02:12I'll press Enter, okay?

02:14And now I know what my hourly wage is, based on my gross salary, okay?

02:24Well, now I want to know how much I earn per day worked, right?

02:31I do it like this, look, I select it here, right? I put the equal sign

02:35I select column G of row 5

02:41And I multiply, right?

02:45By the number of hours worked per day

02:48So let's assume you work 8 hours straight

02:50Right? Of course, in that interval, in that meantime, right?

02:54During those 8 hours there is a break, right?

02:57Then I press Enter

02:58I'm going to win this here, look

03:01R$55.20

03:04What's up, guys?

03:08And that's it, okay?

03:09That's how we are, right?

03:12Do the math, okay?

03:14You know, right?

03:15To find out the value per hour worked

03:17Plus the value per day worked, right?

03:20In this case here, right?

03:21As I said, I did it with gross salary, okay?

03:24Using the salary of R$1518.00, okay?

03:28OK?

03:30And if you liked this video

03:32I ask you to leave your like here on this video.

03:35Subscribe to the channel here too

03:38If you are new here, welcome!

03:40And activate the bell so you can receive notifications.

03:44Whenever there are new videos here on the channel

03:47OK?

03:49I'm staying here

03:51I wish you all a big hug

03:53It cost!

03:56Goodbye!

03:57Goodbye!

03:58Goodbye!

03:59Goodbye!

04:00Goodbye!

Aprenda Como Calcular O Valor Do Salário Por Hora E Por Dia Trabalhado

Categoria

Transcrição

Dicas e tutoriais

Recomendado