EXCEL TIMESHEET Including Calculations for Lunch Breaks - EASY
Create an Excel timesheet that tracks hours worked, including lunch breaks for both employees on day shift or night shift. This step-by-step tutorial is beginner-friendly and perfect for organizing work hours efficiently. Whether you’re managing your own schedule or tracking employee time, this guide will help you build a clear, functional timesheet. Watch now and streamline your time tracking!
CHAPTERS
00:00 - Intro
00:16 - Setup
03:05 - Day Shift Timesheet
06:36 - Night Shift Timesheet
08:47 - Protecting the Timesheet
10:20 - Wrap-Up
📺RELATED VIDEOS
↙️ IMPORT DATA FROM WEBSITE
• Excel Magic: Grab Website Data Like a Pro ...
👓 FOCUS CELL
• Excel Focus Cell - Stop Losing Track of Ac...
% PERCENT OF TOTAL
• Percent of Total in Excel - 3 SIMPLE METHO...
📩 NEWSLETTER
Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://melcompton.com
CONNECT WITH ME!
Official Website: 🌐 https://melcompton.com
Facebook: / melcomtech
Instagram: / melcomtech
Twitter: / melcomtech
LinkedIn: / melissa-compton
Pinterest: / melctech
TikTok: / melcomtech
🧰TOOLS AND DISCOUNTS
My Software:
✅ 🌐 Bluehost: https://melcompton.com/recommends/blu...
✅ 🖼️ Adobe: https://melcompton.com/recommends/adobe/
✅ 🎥Filmora: https://melcompton.com/recommends/won...
✅ ✍️ RightBlogger: https://melcompton.com/recommends/rig...
✅ 🔢 Microsoft Business: https://melcompton.com/recommends/mic...
✅ 🔗 Thirsty Affiliates: https://melcompton.com/recommends/thi...
✅ 📽️ TubeBuddy: https://melcompton.com/recommends/tub...
✅ 🖼️ Canva Pro: https://melcompton.com/recommends/can...
✅ 🌐 Website Theme (Newspaper 12): https://melcompton.com/recommends/new...
✅ 📃 WP Forms: https://melcompton.com/recommends/wp-...
✅ 📧 WP Mail SMTP: https://melcompton.com/recommends/wp-...
My Gear:
✅ 💻 HP Victus 15L: https://amzn.to/42sCr6f
✅ 🖥️ Dell Monitors: https://amzn.to/3r0iwte
✅ 🖱️ Logitech Wireless Mouse and Keyboard: https://amzn.to/42sCr6f
✅ 🔊 Behringer: https://amzn.to/3MW32mu
✅ 🎧 Audio-Technical: Headset: https://amzn.to/2Np3Qpl
✅ 🎧 WC Wicked Cushions Replacement Earpads: https://amzn.to/3uoihuh
✅ 🎤 Elgato Wave Mic Arm Low Profile: https://amzn.to/3UFMJ25
✅ 🎙️ Audio Technical 2005 USB Mic: https://amzn.to/3UHFfM4
🔔 SUBSCRIBE ON YOUTUBE
/ @melcompton
👏 SUPPORT MY CHANNEL
✅ Hit the THANKS button on any video
✅ Amazon affiliate links: https://amzn.to/3Nijfnd
This description contains affiliate links. These are tools I personally use and love. I may receive a small commission should you make a purchase using one of these links. This helps keep the tutorials and website posts coming and up to date. Thank you for your support!
FORMULAS AND FUNCTIONS
Hours Worked Daytime Calculation
=((F2-C2)-(E2-D2))*24
Hours Worked Overnight Calculation
=(MOD((F2-C2),1)-(E2-D2))*24
Overtime Rate
=(K2/2)+K2
Total Hours
=SUM(G:G)
Overtime Hours
=K6-K7
Regular pay
=K7*K2
Overtime Pay
=K8*L2
Total Gross Pay
=SUM(K9:K10)
_________
LIKE. SHARE. SUBSCRIBE.
Give this video a thumbs up if you enjoyed watching 👍
#tutorial #excel #howto
Thanks for watching the video EXCEL TIMESHEET Including Calculations for Lunch Breaks - EASY