How to make an employee timesheet spreadsheet. #excel #googlesheets

Here is how to make a timesheet for employees in Excel or Google Sheets

So I have the names of the employees here, the weekdays, the total days that each one has worked

the total earnings and also the earning per day here. So for the weekdays, we're just going to highlight everything and add checkboxes

We'll go on Insert, then we'll click on checkboxes here. Then for the total days, we're going to count when the day has been marked

So say equals, count if, for the range we'll pick this entire week

For the criterion, we'll say true, enter, and we have the number of days for which every employee has been present

For the total earnings, we'll multiply the number of days times the earning per day

So say equals, number of days here, multiplied by earning per day here

And make sure that this is absolute reference, like so. Enter, and you have the total earnings like that

You can double click to fill the formula, and here we can double click again

Now when the employee is present, the earnings will be increasing like that

It's that easy