Get the pdf employee timesheet form

Video instructions and help with filling out and completing fillable pdf employee timesheet

Hi this is Peter from Swansea tech support code at UK you're watching a video on Excel timesheets how to create a simple timesheet to record staff clocking times so first I thought throw together a simple template that you can use to record clock in terms of your staff and then we'll just tweak a few of those formulas just to kind of give it a more professional touch to the whole spreadsheet but before I begin I noticed that when I create this it comes up with a few error messages you might experience I just want to show you how to turn off a lot of those unnecessary error messages first so if you just come into the file go to options and then just go to the formula bar so you can see here the only ones I actually have checked on here this one and this one all these are the ones I form is referring to empty cells and things like that just really don't matter to me at all um these these are the only two which actually have errors in them so louisianimals actually one showing so just make sure that only those two are checked and click OK on that one and then we're good to go so the format for our table is going to be column headings are going to be day the time we clock in the time we start break okay I just double click that one to enlarge it this time that they finish break okay the time that they clock out and then we're going to have the total time and then you know quite often you need to input this data on another spreadsheet somewhere else or into you know a database somewhere and the of might want you to have the decimal values there rather than the time value so I'll just have their Excel actually convert those into decimals for us as well so the date let's just start today's date which is going to be 14th of March 2012 okay you know just like many UK except on the fourteenth first that's fine okay let's drag these some kind of arbitrary number just because I want to show you here on the autofill options which you have on Excel 2007 and Excel 2010 you can actually come down to fill in the weekdays if you only work Monday to Friday you can fill that in and I also want to change this formatting on here as well because I want to show the what day of the week it is alongside the date there so console number we're going to use a custom number format which is going to be day day day which is going to be a short day as opposed to the long day Y outside they did yeah okay and that will then give us that one if you want to change it to the long dates just come up here one extra D in there and that will then give you the long date Monday Tuesday Wednesday C is so much easier to do it okay there we go okay enough enough nothing about let's get on with this thing okay so we got nine o'clock but they stock in they typically will take their break at about twelve to the bar you know half an hour at 12:30 to be cock out around five o'clock so a decimal time is going to be the time that they clock out take away the time that they finish that break that...