1. Enter the dataset of your employees on the empty cells. Since you're calculating over time you need to have standard working hours. In our case, let the standard working hours be 6 hours. 2. Click on the first cell, within the Overtime column, and then, type this formula 3. Hit the Enter button and you will now have the time difference in hours.

This Excel template for working hours from Microsoft Office works perfectly for weekly tracking. Just pop in your name, email, and phone number along with your manager's name. Enter the date, start and end times, and lunch breaks. The hours you work each day total at the end of the row.