Excel for Begginers

Thiago has a degree in Production Engineering, a graduate course in statistics and a degree in administration from the Federal University of Juiz de Fora (UFJF). Black Belt in Lean Six Sigma, worked with methodologies for cost reduction and process optimization at Votorantim Metais, subsequently joining MRS Logística as a trainee, where he held positions of manager and specialist in continuous improvement. With Microsoft Office Specialist (MOS) certification and ISO 9001 Auditor Lead Advisor, attended several companies in consulting projects, in addition to training and lectures related to Lean Six Sigma, Career Entrepreneurship in nationally renowned congresses such as ENEGEP (National Meeting of Production Engineering) and international as International Six Sigma Brazil congress. In the academic environment, he works as a professor of undergraduate and graduate courses in the areas of management and entrepreneurship. Thiago had the opportunity to participate in projects of several segments. Founder of the Voitto Group, he was selected in the Promessas Endeavor Program, having the opportunity to receive valuable mentoring to accelerate his business. He is currently a business mentor and dedicates himself to the executive front of Voitto, carrying with his team the vision of being the best online school of management in Brazil.

Founder of Voitto Group, currently a business mentor and dedicated to the executive front of Voitto, carrying with his team the vision of being the best online business school in Brazil.

Learn now how to calculate overtime, an important indication within organizations!

Learn how to calculate your overtime with the Excel tab

Surely you&#39;ve heard about overtime worked, haven&#39;t you? Making adequate control over the dates and hours worked is essential. But do you know exactly how to perform your calculation?In this article, I&#39;ll explain how to calculate overtime, in addition to providing you with a spreadsheet to optimize your results.Calculating overtime is essential for any company, which is why it is the subject of our post today. Prepared?<h2>Point Registration with Extra Time Calculation</h2>This registration is the way used by most companies to record the entry and exit times of their employees. Taking advantage of this database to calculate your overtime, also considering holidays and weekends.In addition to explaining what it is and how to calculate overtime, this article aims to present you with a spreadsheet in order to help you control employee points, making it easier to control this information with the automation of most calculations.<h2>Extra time calculation: Understand the tool</h2>The homepage is the starting point for calculating overtime and has the structure shown below. <Image quality="95" width="500" height="500" src="https://images.prismic.io/voitto-blog/a4ff5634-9876-4058-91ee-ee5f33484b8a_Monthly+Records.png" alt="Monthly Records" title="Monthly Records" /> Use the buttons to navigate between the tabs by just clicking on the buttons that direct you to the respective tab.When you click on the arrows located in the upper left corner of each tab, you return to the home page.<h2>Extra hour calculation: General Information</h2>The following image represents the general information tab of the worksheet. It should include information from the user regarding the name, position and monthly salary of the employee. <Image quality="95" width="544" height="177" src="https://images.prismic.io/voitto-blog/ed6ac3df-bbcb-431d-a2f6-172a7fe9a672_TLSS.png" alt="General Information" title="General Information" /> The year of analysis, weekly hours, Sundays and holidays should also be inserted, in addition to the increase of at least 50% of the hour worked.This spreadsheet already is based on the 50% increase, however, this value may vary from company to company. As already mentioned, this value is only the minimum value.It is important to highlight that there should be a spreadsheet of this for each employee of the company. So feel free to copy it.<h2></h2><h2>Extra time calculation: Monthly Point Registration</h2>For each month there is a tab, totaling 12 different tabs. The overview of this tab is given as follows: <Image quality="95" width="941" height="145" src="https://images.prismic.io/voitto-blog/6ee7730b-39d6-43c5-8915-0ed99b22603e_3.png" alt="Monthly Point Registration" title="Monthly Point Registration" /> Columns from D to H are the only ones that need to be filled in the others contain formulas that calculate the total hours worked and overtime.Note that in columns D and H the user must record the employee&#39;s entry times, while columns E and G are the departure times, for each day of work performed.In this part of the spreadsheet, the hours per day are inserted, and at the end, we have the value of hours worked in the month. Thus, the value of the night overtime is already calculated and the value of the salary can also be obtained.If the employee works part-time, for example, the user can leave the time fields blank, so that the hours are not counted.If an employee misses work for some unjustified reason, 0 hours can be inserted in the entries and exits that the total day will be counted in the working day for this employee in the field of negative hours.In the columns of total hours and negative hours, respectively, the total hours worked and the total negative hours (if any) appear.It is important to highlight that times must be filled in as time format (8:00) if the user types 8 only the spreadsheet will not recognize the format as time and this can cause errors in the calculations.Still in this spreadsheet, there is a field for filling out the holiday (column H). As shown in the following figure. <Image quality="95" width="560" height="121" src="https://images.prismic.io/voitto-blog/72b91ad7-0248-4287-a39b-c0ced82d4823_4.png" alt="Columns D and H" title="Columns D and H" />Are you tired of missing out on incredible career opportunities because you don&#39;t know about the main Excel tools?So you are in the right place! In the<a target="_blank" rel="nofollow" href="https://thinkleansixsigma.thinkific.com/courses/excel-for-beginners"> Excel for Beginners</a> course, you will learn to work with data in an agile way.In addition, the course is available for FREE, just click on the banner button below and embark on this journey of knowledge!<a target="_blank" rel="nofollow" href="https://thinkleansixsigma.thinkific.com/courses/excel-for-beginners"> <Image quality="95" src="https://images.prismic.io/voitto-blog/45fd4463-eb50-470d-a2e2-1a98155e7fdc_Bot%C3%A3o++Banner+-+Cursos+TLSS+%282%29.png" width="980" height="180" alt="Excel for Beginners" title="Excel for Beginners"/></a><h2>Extra hour calculation: Report</h2>The report tab is nothing more than a summary of all the hours recorded in the months tabs, as shown below: <Image quality="95" width="598" height="279" src="https://images.prismic.io/voitto-blog/40562a5e-ad7b-413f-a948-401c832f4a24_5.png" alt="Report" title="Report" />Negative hours are the hours the employee owed to complete his time bank.The time bank is the total overtime taken from negative hours. For the calculation of the monthly workday time bank, the period in which the employee made or not overtime is not considered, since an extra hour made on the holiday is more expensive than an hour made during the week.Note that next to each result of the time bank it is possible to appear two symbols (one positive in green and one X in red).X indicates that the time is negative, that is, the employee owes working hours. In the example above, in January the employee owes 25 min and in July he owes 6 hours.Positive symbols indicate that the employee has overtime in the company or that he has no overtime or negative hours. The last group of columns is shown below. <Image quality="95" width="377" height="307" src="https://images.prismic.io/voitto-blog/499cf09f-227c-479b-8ed7-085426cdcdaf_6.png" alt="Numerical Result" title="Numerical Result" />It should be used when you want to perform calculations with overtime values. The previous information is in date format, which is easily viewable.However, when you want to perform mathematical operations with the values of the Extra Hours (such as the total to be paid, for example), it is easier to use this group of information, because it is already within the appropriate format.<h2>If you made it this far, I have a question for you...</h2>Several times we get lost in so many Excel functions, and we don&#39;t know where to start and what to learn. To help you, we created the <a target="_blank" rel="nofollow" href="https://conteudo.voitto.com.br/ebook-primeiros-passos-no-excel">First Steps eBook in Excel</a> to guide your practice with the tool, as well as how and where to learn about its most complex resources. Learn how to solve everyday problems quickly and efficiently in Excel.By downloading our eBook, you will learn the first steps to create your spreadsheets and use their basic and essential functions.Let&#39;s get started?<a target="_blank" rel="nofollow" href="https://conteudo.pocketbook4you.com/ebook-fist-steps-in-excel"> <Image quality="95" src="https://images.prismic.io/voitto-blog/5ad839f3-56eb-4c5b-a198-380f5e858ce8_Bot%C3%A3o+Banner+Cursos+-+TLSS+%2817%29.png" width="1025" height="205" alt="[EBOOK] Fisrt Steps in Excel" title="[EBOOK] Fisrt Steps in Excel"/></a>

Extra Time Calculation: how to do it using Excel

Excel is a great tool for calculating overtime. Learn now!