Okay, now we have got “what the regular working hours are and what the overtime hours is” using these two, we need to find out the total pay.įirst, apply the below formula to calculate “Regular Pay”. NOTE: Change the formula cell format to number format to get a number result.Īfter calculating the regular working hours now, we need to calculate the overtime hour, so apply the below formula to get the overtime hours. This formula will show the result in time, but we need the result in hours, so just tweak the above formula to get the result like 8.5 hours instead of 08:30:00. Now we need to apply the formula to calculate “Regular Working Hours”, so enter the below formula to calculate regular working hours. Ok, now for demonstration purpose, enter one employee’s dummy date for two days. Now it should highlight the rows where the day is either “Sat” or “Sun”. Now choose the formatting color that you wish to highlight the “Sat” & “Sun” dates.
Now we need to highlight the rows wherever the date’s day is “Sat & Sun”, so enter the below formula first. Select the table without headings and click on “Conditional Formatting”, and choose “New Rule”.Ĭhoose the option of “Use a formula to determine which cells to format”. Whenever the weekend comes, we need to highlight those dates, so we use “Conditional Formatting” for auto-highlight these days. Use the TEXT function to convert the date from column B to today’s name. After inserting the column, change the date format to “DDD”. Next to the “Date” column, insert one more column to arrive “Day” name. Now we need to mention the dates involved in the mentioned month, so enter dates from 01 st Jan to 31 st Jan first.
0 kommentar(er)
