Calculating Total Pay For Multiple Employees

Hi,

I am updating an old paper based time keeping system, with an electronic system

I need to find a way for excel to calculate the total pay from 5 days worth of timesheets for 5 employees without having to do it manually. I have attached a sample sheet for your reference.

The actual number of employees to process using this method will be 280, working on 5 machines over 3 shifts, so the attached sheet is only for reference.

Many Thanks

Sue