Hours worked and Overtime hours in Excel [Video]

Hours Worked and Overtime Hours in Excel

Hours Worked and Overtime Hours in Excel

You can download the workbook here to follow along with the Video!

Calculating Hours worked and Overtime hours in Excel can be a tricky thing.

In this Video, we show how to:

  1. Calculate worked hours: We show how to calculate the hours worked for an Employee in Excel
  2. We show how to Calculate overtime hours: We show how to calculate the hours worked after the 8th hour.
  3. We show how to Calculate overtime on a daily basis or a weekly basis: We show how to calculate overtime based on a standard working day of 8 hours and based on a standard working week of 40 hours.
  4. We show how to handle Night shift Calculations: We show how to calculate working hours when we have Night Shifts which could be a bit tricky. We show we can use the MOD() function to handle this issue.

To be able to fully grasp this Video, you need to be aware of how date and time work in Excel. You can watch my Excel Date and Time Masterclass below:

You can also download our Excel Date and Time CheatSheet using the below form!

Please share

If you like this post, don’t forget to Share it with your friends on different social media platforms using the share buttons!

Ace your Excel Career by learning how to create Excel Dashboards!

Learn Step by Step how to create Professional, Interactive Dashboards & Charts using Excel including:

1- Learning the Important functions that you need to know for building Dashboards such as VLOOKUP, HLOOKUP, MATCH, INDEX, OFFSET and others

2-Learning how to implement Interactivity tools such as Form Controls, Slicers, and others.

3-Learning Dashboarding techniques.

4- Building a Complete Excel Dashboard.

Click here Find out more

This is one of the most helpful and comprehensive dashboard classes I have taken. I was able to take what I learned in the evening and apply it at work the next day. I created a compensation dashboard and my boss was amazed! Thank you Abdelrahman Abdou for an awesome class.

Mary Templin

By |2018-10-14T15:02:33+00:00October 4th, 2018|Uncategorized|0 Comments

About the Author:

Hello, I'm Abdelrahman, the founder of Excelbonanza.com I'm an Excel enthusiast and Data Analyst with 7 years of Experience in the Telecom and Customer service industry. I'm here to share my knowledge with the world and help people become better at Excel!

Leave A Comment

Send this to a friend