How To Make a Simple Time Sheet In Excel

[@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 ❤

[@olgacotto7915]

Very helpful! Thank you!

[@estherbfs]

Thank-you for your clear explanation!

[@cyndicorinne]

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

[@ghetrojetlerazan1910]

Thank youuu

[@nova-on9xu]

You should make a QnA video 😍

[@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)

[@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

[@meenakg9018]

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

[@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

[@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

[@sftniausmn]

me too how ya 😢

[@omojiraabdulai2761]

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

[@okuu_utsuho]

Notifications squad

[@jackblack8327]

Double Time? Meal penalty?

[@gocareer7698]

great 🥰

[@kevinmathew3737]

what about time in at PM and time out at AM

[@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