Excel task

Create an Excel chart of the hours worked for each of these employees.

If the employee worked over 8 hours, they will receive overtime pay.

Create a sub total for that week for regular hours and overtime hours worked for that week.

Each employee is also required to take an 30 minutes unpaid lunch break

If employee taken lunch over 30minutes calculate the excess time they have taken.

Time worked

8/1:

Smith, John Start Time: 9:00 AM; End Time: 9:00 PM; 1 hour for lunch

Johnson, Robert Start Time: 9:00 AM; End Time: 6:00 PM; 1 hour for lunch

Bierman, Juliet Terry Anderson Start Time: 9:00 AM; End Time: 8:00 PM; 30 minutes for lunch

8/2:

Johnson, Robert Start Time: 9:00 AM; End Time: 5:00 PM; 45 hour for lunch

Bierman, Juliet Start Time: 10:00 AM; End Time: 10:00 PM; 60 minutes for lunch

Smith, John Start Time: 9:00 AM; End Time: 3:00 PM; 30 minutes for lunch

8/3:

Bierman, Juliet Start Time: 10:00 AM; End Time: 6:00 PM; 30 minutes for lunch

Johnson, Robert Start Time: 8:15 AM; End Time: 6:00 PM; 45 minutes for lunch

Smith, John Start Time: 7:00 AM; End Time: 5:30 PM; 45 hour for lunch

8/4:

Smith, John Start Time: 8:30 AM; End Time: 8:30 PM; 30 minutes for lunch

Bierman, Juliet Start Time: 9:45 AM; End Time: 8:45 PM; 1 hour for lunch

Johnson, Robert Start Time: 9:45 AM; End Time: 6:30 PM; 1 hour for lunch

8/5:

Smith, John Start Time: 7:30 AM; End Time: 4:30 PM; 30 minutes for lunch

Johnson, Robert Start Time: 9:45 AM; End Time: 9:00 PM; 45 minutes for lunch

Bierman, Juliet Start Time: 3:00 PM; End Time: 10:30 PM; 1 hour for lunch