Learn How To Make Timesheets In Excel Using Simple Steps

Learn How To Make Timesheets In Excel Using Simple Steps

Hi. To learn how to make timesheets in Excel, open MS-Excel and click on file to create a new workbook. Then, prepare a table in it following which enter relevant data into it. If the dates being entered by you are not in the data format, then, from the home menu, click on the number format box from the number group. Afterwards, mention the date in the list. Next, the weekdays should be entered in the table as well. From the home tab, select the number option and after the format cells dialog box appears, select custom from it. Enter dddd in the typing box provided, select it and then click on OK. Click on data tab and then data validation to enter validations for the columns related to time. Also mention the start time as well as the end time following which click on OK.

Also add validations for the columns named sick and vacation and then enter the data into these columns so as to calculate the working hours of the employees. Save the file by clicking on the save option. Also give a name to the file and select the file extension as .xltx. Hope we helped.