Calculation of wages/salary|Excel challenge 3 Solution|Excel Time Format|Conversion of time format|

Here is the solution to third challenge!!
Suitable for HR/Finance
Difficulty level Medium
Completed file available in https://rb.gy/kp3x7
Detailed video in    • Calculation of wages/salary | Excel 3 Solu...  

Steps: -
1. Freeze pane
2. Difference of clock time in HH:MM format
3. Why HH:MM format needs to be converted into numbers
4. How HH:MM format can be converted into numbers
5. Difference of clock in number format (as hours)
6. Hours of break taken separately using ‘Left’ function
7. Why Character position of 'space' after minutes is required
8. Character position of 'space' after minutes using ‘Search’ function
9. Minutes of break taken separately using ‘Mid’ function
10. Break time in HH:MM Format using ‘Concatenate’ function
11. Break time in number format (as hours)
12. Revised clock time (after deducting break time)
13. Salary computation without OT using ‘If’ function
14. OT Computation using ‘If’ function
15. Total Salary using ‘Round’ function and ‘Sum’ function
16. Taking unique names using remove duplicates
17. Total Salary for the month using ‘Sumif’ function and making the range constant
18. Control check

@EIAMalayalam for Malayalam content

#Excel #Excelchallenge #Excelinsightsacademy