I'm going to show you how to create a roster of your your staffs timesheets
with linked timesheets so we have here a list of employees and the hours that
they have done and then you have a total hours for the for the day how many hours
you have charged it against you and then at the end of the month you have earlier
at the end of the thing you have a total hours for this each individual now let's
show you a few things that I've done here so my start date is is March 1st
2018 so I could change that to April and then all my weekends will change and how
I have done that is I've conditionally formatted this I've got this whited out
but this equals weekday of c5 which is here and if there if the weekday is
either 1 or 7 1 being Sunday and 7 being Saturday it's grayed out and basically
how I did this so lets me change it back to March I put each so the first the
first is equal to this cell here but how I've increased the day is I've equal to
just added one to the date now how I formatted this is I formatted this
format cells and I went custom and I'm just asking for the day they know it's a
date they're the only thing I want to see is a day so I wanted to see the
letter see the 1 2 3 up to 31 ring okay so now what I have here is for each of
these individuals is I have an employee I have employees I have others actual
timesheets linked here so let's go to employee 1 and you can see there's an
employee timesheet here and here you have time in at 8:00 time out at 12 and
he's back at 1 now it works particularly well if he used a 24-hour timesheet and
so then I've done the same thing with the days along the side here and then I
have created a formula here and so what I've
done is I've just I've taken d3 minus c3 and then I've added F 3 minus F 3 minus
e 3 and then because it's going to give you a fraction what I've done is I've
multiplied it by 24 and so you'll get the hours this way now these are linked
so let's take let's pretend this guy didn't work in the afternoon so let's
put zero in here and so he's got four hours and so now I go back to my main
sheet and there you see he's got four hours now on on there so this this is
how you link the time sheet so basically what all it is is it equals equals and
an employee 1 and then it's got the cell that it's linked to now your timesheets
won't normally be on the same sheet as your roster is so let me just show you
something here so what I'm gonna do here is I'm gonna go and I'm gonna copy this
so if you if your computer's you could have their timesheets on their
individual computers now let's just change this to employ 3 so let's go 3 so
what I'm gonna do is I this is a totally different workbook and so now I'm gonna
go back to my roster and so I'm going to go employee 3 so I'm going to go equals
and I'm going to go to the other worksheet and I'm gonna click on the
total for the day first day and as you can see now it says book 1 because I
haven't named this sheet 1 and G 3 and there there you have the hour of Sprott
overview so you can link each equally now if you're in a network everybody can
have their time sheet on their own on their own computer and it would work
just fine so this is how you create a roster of
them with linked timesheets this will be
available if you you'd like to get a copy of this just email me please
subscribe