on this video we are going to discuss how to combine timesheets to make a payroll summary
on a previous video I discussed how to make a time sheet and I have a link in my notes
below so what we would like to do is we have a staff
of four here and so we have sheets for each of them Tom's timesheet, Cathy timesheet and
they have each entered their own hours here and what we would like to do is combined these
hours for a payroll summary we are going to and go to Tom's sheet here and we will select
the top three rows here so we have the date to where it says tasks and then we will go
right to the thirty first and then we will go copy and then we will go to our payroll
summary and go one row down and then go paste now we will change the tasks to days now I
have previously changed the column widths of B to AF if you right click on the column
you can see that the column width is 3 so you need to do that so the it fits on one
page.
so now what we are going to do is put the first staff members name in here and to it
is Tom and then we will put equals so now we are going to go back to the tom sheet and
we are going to click on the totals here for each of the days so we are going to click
on the first one which is zereo and press enter and the zero is entered in the summary
sheet and we are going to drag until we get the the end of the thirty first.
and then we will take an automatic sum of these numbers, I have done this for each of
the staff so that you do not have to watch me do it and I put it on the next sheet and
so here you have the staff members and their hours totalled up here and if you were paying
20 dollars and hour what we have done here is multiplied the hours by twenty and this
is the salary that you have to pay now these sheet are linked and not copied so lets go
to Cathy and she comes and says she forgot to enter hours in so now if we look the total
for Cathy is 18 hours so lets to the cathy sheet and enter in hours so now you can see
on this sheet the total is 66 so lets go to the summary sheet which is sheet six in this
case and there you have the 66 so the hours have automatically been carried over so that
is how you combine timesheets for a payroll summary.
Please Subscribe