How to Automate Semi-Monthly Employee Timesheet Template in Excel for Payroll

How to automate a semi-monthly employee timesheet in Excel using formulas to auto-populate the dates in the pay period, and use special conditional formatting tricks to hide or display all the dates in your pay period range on the timesheet. We'll set up a drop-down list for PTO type selection, and then see how to set it up for calculating hours, overtime, and total pay. This template will automatically update the pay period end date, and all days and dates in the pay period based on entering/updating the pay period start date. Also, simply enter base pay rate and all other totals will auto-calculate.

Check out my other videos on timesheets:
   • How to Create Employee Timesheet Temp...   - Create a Timesheet Template from Scratch
   • How to Automate Bi-Weekly Timesheet T...   - Automate a Bi-Weekly Timesheet

Link to purchase the fully automated templates if you are interested in getting a jump start: https://www.etsy.com/listing/17450728...

TIMESTAMPS ⏰
00:00 Automate Semi-Monthly Timesheet
00:24 Excel Semi-Monthly Timesheet Template Overview
01:15 Auto-populate Dates with Formulas
02:50 Conditional Formatting to Hide/Display Dates on Timesheet
05:00 Create Drop-Down List in Excel for PTO Type
06:05 Timesheet Calculations and Formulas
07:50 Timesheet Formatting Tips

COURSE 🎒
Create Fillable Forms, Surveys & Questionnaires in Microsoft Word like a Pro:    • Creating Fillable Forms in Microsoft ...  

CHANNEL LINK 📺
   / @sharonsmith  
Visit my Channel page on YouTube to see all my videos, playlists, community posts and more!

TEMPLATES 📄
Check out my helpful list of templates available for purchase: https://creatoriq.cc/43c51cv
Thank you for supporting my channel! 🌟

FREE DOWNLOADS ⬇️
✦ Visit https://mailchi.mp/6a0859ea0844/sharo... to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.

CONNECT WITH ME 📎
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn:   / sharonsmithhr  
Twitter:   / sharonsmithhr  
Instagram:   / sharonsmithlearning  
Facebook:   / sharonsmithlearning  

GEAR ⚙️
🎙 Blue Yeti USB Microphone: https://amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
🖱 Silent Mouse: https://amzn.to/3pxpc25 (This is a really cool mouse!)
🎥 Screen Recording Software: https://techsmith.z6rjha.net/NZG5b
📗 Green Screen: https://amzn.to/2DnHsY2
📸 Camera: https://amzn.to/39KvpQA
🔌 Live Stream Tool: https://amzn.to/2VFJyID (Turns your DSLR into a top notch webcam)

RESOURCES 📚
✏️ JotForm: https://www.jotform.com/pricing/?utm_...
🖥️ TechSmith Camtasia Screen Recording: https://techsmith.z6rjha.net/SharonSm...

Links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!

SUPPORT THIS CHANNEL 🙌
Hit the "$Thanks" button on any video, or
Donate through my PayPal link: https://www.paypal.com/cgi-bin/webscr...

If you found this content helpful, please consider donating to my channel. Your donation, no matter what amount, is greatly appreciated and goes towards producing more content that enhances your productivity and elevates your skills.

You can also support my channel just by watching, liking, and sharing all my videos! Thank you so much! ❤️

PLAYLISTS 🎥
➤ Jotform Tutorials:    • Jotform Tutorials  

➤Create A Letterhead in Word:    • Create A Letterhead in Word  

➤Creating Fillable Forms:    • How To Create A Fillable Form In Micr...  

➤PowerPoint Tutorials:    • PowerPoint Tutorials  

➤ Excel Tutorials:    • Microsoft Excel Tutorials  

➤ Excel Tips & Tricks:    • Excel Tips & Tricks  

➤ Word Tutorials:    • Microsoft Word Tutorials