How to Make a Weekly Timesheet Calculator in Microsoft Excel

I hope you enjoy! Please remember to comment, like and subscribe. We will be posting more videos. Your suggestions are welcomed!!!

3 Simple Reasons to Subscribe:
I'll listen to your feedback
I'll do my best to produce quality and useful videos
Smart people surround themselves with smart people ;-)

[VisioDeZ]

I have had tremendous interest in this video and the Excel file. For those of you who just need the file I have updated the link to my own website and this should work permanently. I am giving this away free HOWEVER it is for your own use only, it may not be sold or distributed.

[luismorales]

Thank you. I followed your tutorial and I'm giving it a try. I have 4 workers and I enter their times myself from their texts-in and out as they come in and leave every day weekly. Your download link provides an error. No matter, I rolled up my sleeves and made my template by starting and stopping as I entered your moves on my sheet. Grateful for your effort.

[klondyguerra]

Thanks so much, it was so clear and easy to follow. I recreated your spreadsheet while listening to you, so I really understand it. I feel so happy.

[susanallen]

Excellent and easy to follow. I actually starting to understand excel functions. Thanks for not adding distracting music.

[pattyt]

Thank you for explaining line by line row by row. I watch 3 other videos and it was not as easy as yours.. Thank you again

[sareychim]

Thanks! I followed along EXACTLY how you've demonstrated and it turned out just like the one you've presented. Thanks, again! =)

[mrsvirgoqueen]

YOUR VIDEO WAS A GREAT HELP, ESPECIALLY SINCE I HAVE BEEN OUT OF THE WORK FORCE FOR OVER 3 YEARS. THANK YOU

[sneekymuffin]

You are a life saver! We used to have at time card punch that did military time but that one broke so I had to figure out an easy way to calculate hours with out it taking hours to do! We only have 1 pay period per month so I just added 4 of these columns and at the end I'll figure out a way to add up all the total hours!

[leydicoba]

Great video. Easy to follow. Precise.
Thank you!

[manriquezabel]

THANK YOU SO MUCH FOR TAKING THE TIME TO POST THIS VIDEO! I NEEDED THIS! I APPRECIATE IT.

[mifamilia]

Love it this was very helpful because I was not keeping track of my hours were I worked and for some reason my check would not make sense. So thank you

[PicknTime]

Thanks! This is great and easy to follow. Someone (Michelle Hubbard)had ask, how do you replicate this (i.e. make a copy for multiple employees)? It's simple, in the workbook, right click on the sheet tab of existing time sheet. Then click "Move Copy", check the "Create a Copy" box, click OK. The new time sheet tab name will be: Original sheet name (2).

[salvxmerey]

Thanks for the tutorial friend. I really appreciate it. GOD bless you.
Sucks that lazy ppl comment so that you do the work for them instead of asking for help or also complain claiming that this does not work. SMH
Teach a man to fish... Some ppl are comfortable just getting the fish instead.

[jasontatoy]

Thanks for this tutorial. It is a great help.

[sibonisoclivance]

Fantastic man....much appreciate working

[beliatenorio]

Wow!!! This helped me much!! Thank you!!!!

[MrRicks]

How can I create a monthly timsheet with fixed weekly format monday to sunday. 1st of every month should auto fits into fixed weekly format?

[rtrgrl]

Thank you, very useful - may I ask how would I enter a a double overtime rate? but sill have an overtime column as well? thanks

[Lynchmob]

How would I write the formula to express all hours over 8 each day are at 1.5 or but if they don't reach 40 hours in a week but work on weekends and go over 40 all hours are at 1.5?

[Neptune]

Neat, even if it avoids short cuts in construction.