It's as Easy as This How to Calculate Hourly Overtime Wages. Calculating hourly overtime wages, you must first know 2 components, namely Basic Salary, and Fixed Allowances. Then the two components are added together. Then the result is divided by the number 173, then the quotient is the hourly overtime wage.
There are three types of hourly overtime pay, namely:
1. Overtime on weekdays: for example an employee who works from 7 am to 3 pm. Then he continued to work until five o'clock in the afternoon. Thus the employee worked two hours overtime.
2. Overtime on holidays: an example of an employee working 6 days in 1 week. Then he works on the 7th day, then works on the 7th day and is counted over time starting from the first hour until he comes home.
3. Overtime on national holidays: if an employee works on a national holiday or what is commonly referred to as a red holiday.
An admin must be able to calculate overtime pay. Besides that, the admin must also understand another formula, namely the Vlookup formula.
By understanding the use of the vlookup formula, an admin can complete and make things faster. Office admins must know how to use excel lookups properly. The vlookup formula can retrieve data from different sheets. Vlookup different sheets really need to be mastered by an admin or someone who is going to apply to become an admin. On this channel, it is easy and simple to explain how to do a different sheet vlookup formula.
#formulaexcel #belajarexcel #excelvideotutorial
23 сен 2024