In this article, I will show you how to create a timetable in Excel. You can also use templates for timekeeping.
| Join the channel Telegram of the AnonyViet 👉 Link 👈 |
How to create a timetable in Excel
1. To automatically fill in the day and date, please use the formula below.
2. Select the cells that contain the time you want.
3. Right click, click Format Cells and select the appropriate time format. Use the circle format in the image below for cells K12, K13 and K14.
4. To automatically calculate the number of hours worked per day, total hours, and overtime hours, use the formulas below.
In addition, you can also view many other excel articles here.
