How to Create an Automated Timesheet

Learn through step by step how to design an automated timesheet template in Excel while mastering some advanced skills to handle dates, and also some mastery stuff with conditional formatting!

[amitprasad]

Awesome tutorial, clearly explained, thanks.

[juliolazaromucavele]

Many thanks, I have succeed on this. From Mozambique

[smartnewenergy]

Thanks for the good video. Regarding your example, I have placed the days of the month vertically and I use not the column function but the line and it works perfectly. If we have 10 employees, the working days are placed vertically at the beginning of the work type and concern all 10 employees. But in the calculation for working hours and overtime pay, For example we have payments in the first 8 hours of work ($1.00) X 1, in the 9th hour ($1.00) X 1.20, in the 10th hour ($1.00) X 1.40(only 150 hours per year allowed), 11th hour ($1.00) X 1.60, more than 11th hour worked ($1.00) X 2.20, also night hours get an extra ( $1.00) X 0.25, also for offsite work (work in another city) they get an additional 10% or 15%, so I have them placed in different columns. The first question is what formula should I use? and the next is the following: on Saturday the first 8 hours of work ($1.00) X 1.30 and overtime on Saturday ($1.00) X 2.30 and on Sunday or a public holiday the first 8 hours ($1.00) X 1.75 and overtime ($1.00) X 2.75 but in Timesheet Automation we have the days of the week in some cells and Saturday and Sunday in some others, next month they change position, so a formula e.g. (if(Sunday=(calculation of hours or overtime ); if(not Sunday); "blank cell" same for Saturday. Also for days of the week e.g. (if(Monday, Tuesday, Wednesday, Thursday, Friday =(calculate hours or overtime ); if(not Monday, Tuesday, Wednesday, Thursday, Friday); "empty cell")
Also, how will the formulas contain if(official holiday =(calculation of hours or overtime); if(not official holiday);"empty cell"
Thanks for the help and I apologize if I bore you with the long comment and I look forward to your help
ps : all the above are for example for the production of the formulas and do not really exist!

[BillyJoe-gkud]

do you have a tutorial how to put computation based on that format? ty

[haifaalinoora]

Good teaching video, you are a very helpful

[BertoniFlores]

hello! when I tried to use the link to try to create a copy and follow along, the template was not empty. how do I fix this?

[humaynarimanova]

Great, fantastic... Thank you very much.

[sonaimuthu]

Very use full ur video but if i am enter one monh time sheet completely then i will go next month my previous month record will not come as weel ass i will record when previous month details also .any idea?

[DellaHalvorson-jf]

My head hurts but it works! Mahalo nui loa!!!

[amitprasad]

Hi, Your download link is not working.

[BertoniFlores]

hello! when I click on the link the template it's not empty, how do I fix this?