Microsoft Excel - Employee Daily Time Sheet & Weekly Hours Calculation

100+ employee daily time sheet that integrates into a weekly payroll sheet broken down by employee and which department they worked in each day. Some days they might work in more than one department so that time must be broken down to account for that. The sheet must also account for part time daily workers that are added to a sheet on any given day and also added to the weekly payroll sheet.