Add Weekly Timesheet Template Signature Service with airSlate SignNow

Lay spreadsheet log

hi there folks and welcome back to another tip for Microsoft Excel today we're going to be looking at a different option for you to build your own timesheet so a timesheet would be used to help the hours work or to keep track of maybe a contractor or a contract position or something informal you you wouldn't use this for like an entire organization well you could use a timesheet but we build a little bit differently this is going to be for managing the time of an individual so let's get started here the first thing we want to do is create a row that we can always see we don't want anything disappearing so to do that we're going to just freeze the cell make it stand out a little bit give it some information and so we're going to say date worked we're going to say time in and we're going to say time out not the kind of time out where you got to sit in the corner just the time when you get off work and you go and rest and so our next one is going to be total hours worked and and we're going to create one more and we're going to say gross pay you know it's not gross to ever get paid the gross pay is simply the total amount we're going to need a few pieces of data here and so we're going to just create a box over here that says hourly rate and we'll keep with the beautiful format here and we're going to make that one yellow also just put a nice little border on it and then we're going to format this in a dollar and we'll say that the hourly rate is thirty five dollars okay and let's say that just for kicks you want a additional information column so you know what it is the person is working on so we're going to open that up a little bit and we'll format it by wrapping the text so that they can put in as much information as they need and it won't get all crazy so now we got everything formatted and we're going to go ahead and put a border here real quick and then we're going to also format this and we'll just click on the entire column a right click go to format cells and we're going to come right over here to date and let's say we use this one here we want the day the month the date and the year and so let's say that we were creating a time log for May 4th 2017 and of course we want to format these too and so we highlight both of them and we're going to come over here to time we're just going to give it a basic 1:30 p.m. type format and so what that's going to do is let's say we clock in at 7...