Dates adn times in excel

Hi Alison

Thank you for your question and welcome to the forum.

Things that you might find useful in regards to setting up a timesheet:

1. If you are using this to calculate pay, formulas to add up hours and then calculate pay by multiplying total number of hours by rate. The SUM function can be used to add daily number of hours together; and * is used to multiply, e.g. =A1*A2 will multiply the values in A1 and A2 together.

2. Saving the timesheet as a template, so you can start a new timesheet each week. When you save the file, change the file type to Excel Template or Excel 97-2003 template next to Save as type when saving.

3. You may like to include protection in the template so that whoever is using it can enter in their hours and can't overwrite any formulas in the timesheet.

I hope this is useful.

Kind regards
Amanda