How To Make a Simple Time Sheet In Excel

This video explains how to a make a simple time-sheet in excel. It discusses how to calculate the total hours worked with a lunch break included. It also explains how to calculate the weekly pay with overtime pay included.
Excel Tutorial For Beginners:
• Excel Tutorial For Beg...
Top 30 Excel Tips & Shortcuts:
• Top 30 Excel 2016 Tips...
_________________________________________
How To Calculate The Total Hours Worked:
• How To Calculate The T...
How To Make a Time-Sheet In Excel:
• How To Make a Simple T...
How To Calculate Loan Payments In Excel:
• How To Calculate Loan ...
How To Create an Amortization Table:
• How To Create an Amort...
Excel - Business Account Ledger:
• Business Account Ledge...
________________________________________
How To Look Up Customer Data In Excel:
• VLookUp - How To Extra...
Excel Vlookup Function:
• How To Use The VlookUp...
How To Create a Data Entry Form In Excel:
• How To Create a Data E...
Multiple Dependent Drop Down Lists:
• How To Create Multiple...
How To Show & Hide Formulas:
• How To Show and Hide F...
______________________________________
KZbin Channel Growth Accelerator:
/ youtubechannelgrowthac...
Final Exams and Video Playlists:
www.video-tuto...
Full-Length Math & Science Videos:
/ collections

[@ganeshkhatiwada4605]

U are simply the best. Just the video I was looking for.

[@Billsomebody89]

Thank you! Keep the Excel sheets coming!!

[@ChristinaRamirez-l6k]

I need help calculating a monthly time sheet and was hoping you had a video on this?

[@Petertangeria-h6h]

Useful information. Thanks ❤

[@cyndicorinne]

This makes sense. Thank you for the explanation of overtime calculation!

[@olgacotto7915]

Very helpful! Thank you!

[@estherbfs]

Thank-you for your clear explanation!

[@meenakg9018]

One doubt in weekly payment formula.. total hours 51 right then why calculate overtime also again

[@ghetrojetlerazan1910]

Thank youuu

[@nova-on9xu]

You should make a QnA video 😍

[@rafaeltejeda6199]

Thanks for this, but question, if I wanted the sheet to add H and V as 8 hours for holiday and vacation, how can I write that formula. Been having hard time trying to come up with it. Thanks in advance either way

[@emmanuelobare2902]

Good work done, my worry is about the employees, pls can u add more to the names for us to learn and see how it feels

[@qusaishah8117]

Hi I need help I am doing night shift and I work from 8 pm to morning 9 am That's 13 hours. But when I enter my time in time sheet instead 13 hours it minus the hours it shows 11 hours . Can u explain please

[@erinusman378]

me too how ya 😢

[@tkondja]

I wish you could’ve included work on a night shift, e.g starting from 06:00PM to 06:00AM, I struggle with such formulae in Excel

[@drag0nblight]

It is complicated for Excel. My trick is to use time code, i.e. the numerical value of dates and times used by Excel for computation. Even for that, I have a spreadsheet with excessive, for my liking, amounts of cells with formulas. On top of that, my tables are less intuitive for others to use. The excessive formulas are for night pay calculations.

[@asarand]

I know this is a year old, but I have a partial solution. It has the drawback of lunch breaks being between 11PM and 12 AM, so if the lunch break ends before midnight or the break occurs after midnight the calculation won't work. I don't know how to do a IF ELSE ELSE in Excel. The formula I have worked out is: =IF(B12>12,((B12-B9)-(B11-B10))*24,((B12-(B9+12))-(B11-(B10+12)))*24)

[@jackblack8327]

Double Time? Meal penalty?

[@okuu_utsuho]

Notifications squad

[@omojiraabdulai2761]

Show a time sheet having both breakfast and lunch and you work for over 12 hours

[@kevinmathew3737]

what about time in at PM and time out at AM

[@gocareer7698]

great 🥰

[@yznrt7873]

Can you make a video about air drag and terminal velocity for ap physics

[@joetrevor2258]

why does it sound like mark wahlberg is narrating this

[@safalcapital]

time sheet me half day kese count kar sakte he kisi ko pata he to please bataye