Thank you! This is the first video I've found that answers the simple question of turning "time worked" into a base-ten number (i.e. "4.5 hours" rather than "4:30 hours"). Such a simple concept, but no one else did it!
@suzf5045
2 жыл бұрын
I literally have this video on .25 playback speed and I am STILL having to rewind to catch everything! You are a PRO! Thank you for the free lesson albeit head-spinningly fast!
@nguyenthanhhaidang
5 ай бұрын
🎉😂
@kr0nz
2 жыл бұрын
One of the best trainers I've ever watched on KZitem. Excellent video, easy to follow. Thank you!
@skylartaylor4493
Жыл бұрын
Haven't used Xcel since high school, this really helped refresh the memory. Thanks a lot!
@nguyenthanhhaidang
5 ай бұрын
🎉😅
@demisalcedo8486
6 жыл бұрын
This formula and instruction was totally worked for me. Thank you! :)
@nokpiadariusconstantino1333
2 жыл бұрын
Ganbayvwjbaibqyqoozbajvakwbgwoiqoqoqivsyqivwkbw
@saadramzan6092
3 жыл бұрын
Good job bro. You're sorting out my many many misconception about time sheet. It's mush pretty easy more than i thought. I grab your points and your understanding level is outstanding. Thank you God bless
@HilalAhmad-kr5tk
2 жыл бұрын
Easily understand to me. Very simple way explained! Thank you boss
@robzecart2428
3 жыл бұрын
excellent, I was looking for this exact example!! very well and organized!! thank you so much!!
@nokpiadariusconstantino1333
2 жыл бұрын
Виовтрутлуигдулоудлцдзцзхцзцзщцтвшао
@andreabrownjames1141
7 ай бұрын
This was an awesome tutorial thank you so much my company hasnt set up a way for me to track my time yet and this came in sooooo handy thank u
@ralitsadimova9623
5 жыл бұрын
A useful tip, that you can add to your video description: 8:26 min > if you use a Macbook press Command+T to lock the cell F4 doesn't work for Macbook :) Thanks for the video anyway was really helpfull :)))
@HauntedandStunning
4 жыл бұрын
Thank you so much for this tip!!!
@CarlaHBrown
4 жыл бұрын
Excellent! I was wondering!
@CarlaHBrown
4 жыл бұрын
Actually Ralitsa, do you know how to do this with Google Sheets? I took this lesson and translated it to Google sheets. When I hit "command T" it opens a new webpage
@rosehoffman9221
6 жыл бұрын
Super simple and very easy to follow. Worked great!! Thank you
@florastucker1804
5 жыл бұрын
Thank you so much for your excel tutorial to teach us how to calculate the work hours. I 've just done my first total work hour for the week. 😎✔
This worked... Until I had shifts that started at 9:30 AM & ended 12:30 AM.. Then the formula read -9 hours.... So working on a correction for that. But thank you for this base set up!
@DIgitusSmartas
3 жыл бұрын
try this as formula here are only for hours that finishes within 24 hours, I had the same problem and found IF formula to correct that. copy this formula but change the numbers of cells and columns letters with where your data is. =IF(G24>H24,H24+1,H24)-G24. Helped me, not sure if there is easier way as my brain is rusty, havent used excel in 12 years.
@charlottecountyriders
2 жыл бұрын
Then you would have to add the 30 minutes to the next day. That’s on every program.
@RIZBANDIT
Жыл бұрын
very helpful as i learning a new job. excel is going to be my best friend for the foreseeable future
@amblessed8657
4 ай бұрын
Woww thank you, it helped me in 2024. Great job.
@SyahDzul7979
Ай бұрын
Thank you so much for sharing this sir! Really helpful for me as a newbie in Excel. Explain well and easy to follow👍🏻👍🏻 double thumbs up for you sir
@KutteesChoice
Жыл бұрын
Great video! Explained very well.
@luizahajdu5457
2 жыл бұрын
Thanks! Super simple and easy to follow.
@LindaKnFL
3 жыл бұрын
Thank you for these simple instructions, it worked perfectly.
@EdsonNascimentoEN
Жыл бұрын
Great tutorial - straight to the point. Thanks
@JoseRodriguez-un2kc
4 жыл бұрын
Dude! You are the man. This helps.
@gigeedesign
Жыл бұрын
hi, I really like the way you teach, amazing, thanks from Afghanistan.
@ericross8202
6 жыл бұрын
Excellent Presentation I followed along and created my own individual Time log. Thanks.
@CarePeers
4 жыл бұрын
Thank you for sharing, so that I can keep track for my business development progress.
@peteradeteacher1380
4 жыл бұрын
check this video for more. like and subscribe. kzitem.info/news/bejne/kpeY0HaojKOFoaA also am selling a template that makes multiple timecards and can also produce payment details in totals. my email for any question ptakim.pk@gmail.com
@voncastro919
6 жыл бұрын
How do I calculate the break duration from their time in and time out
@martinjooste8804
2 жыл бұрын
Bro this video helped me so much ...thanks bro ...
@severinoarraro5821
2 жыл бұрын
thank you for sharing this, this video is very helpful to me
@shmalan9698
2 жыл бұрын
can you help me figure out how to do a lunch in and out punch. where it will calculate a unpaid lunch time and remove that from the total shift hours. thanks!
@dennisschmidt975
2 ай бұрын
This is exactly what I need thank you.
@ashtonghost4470
3 жыл бұрын
this helped wonderfully and I was even using Google sheets.
@roedhunt
3 жыл бұрын
Thank you soooo much! Easy to follow!
@nokpiadariusconstantino1333
2 жыл бұрын
Hagqibaoba
@mekepnava4114
3 жыл бұрын
Thank you for this sheet. I really needed it. You have yourself a new subscriber.
@thebesttechnical3608
5 жыл бұрын
You are wonderful. Thank you for sharing this extremely helpful information.
@jafdynasty
Жыл бұрын
Thanks! indeed super simple and easy to follow...
@memberinformation5888
5 жыл бұрын
Matthew 28: 19-20 Go ye therefore, and teach all nations, baptizing them in the name of the Father, and of the Son, and of the Holy Ghost: Teaching them to observe all things whatsoever I have commanded you: and, I am always, even unto the end of the world. Amen.
@thestraightpath9238
3 жыл бұрын
wonderful tutorial it helped me make my first excel timesheet thanks
@dianamoore1616
2 сағат бұрын
Great Video. Do you have a video for working Overtime as well to be calculated into Total Paid Hours for the Day?
@zhugeliang3905
2 жыл бұрын
Very simple to follow. I need to add the lunch hour taken and subtract that from the total hours worked.
@abigailmaturana741
5 жыл бұрын
biiiiiiiiitch you so fckn VALID i had to go through so much bullshit to finally find this pot of fck GOLD; YOU ACTUALLY GIVE THE NEEDED INFO not all this unnecessary fluff!!! and crap i didnt ask for!! woo!!! YOU ARE AMAZING! I LOVE YOU THANK YOU SO MUCH!!!!! keep AT it my dude!
@tradingeasymoney4873
Жыл бұрын
Realy nice and super
@JW93HB07
2 жыл бұрын
Thanks buddy! This is fantastic.
@soniamirza7978
2 жыл бұрын
Thank you for the tutorial its very helpful.
@funnyshah3026
4 жыл бұрын
Thankyou Sir for your best advise and best learning
@anitasmith3124
11 ай бұрын
Absolutely the best. Can you do one for Time difference.
@robertgregory7101
Жыл бұрын
Great instructional video, thank you for the channel. I have a 30 minute unpaid break, is there anything I can add to the formula to subtract 30 minutes each day? Right now I'm just making my time out 30 minutes less than the actual time.
@ZafarAli-kh4ri
Жыл бұрын
Thank you you are awesome teacher
@lewishayler3058
3 жыл бұрын
If hitting F4 doesn't lock the cell, hold the "Fn" key and press F4.
@echery3950
2 жыл бұрын
Thank you! The F4 wasn't working for me
@jamilaldubai391
5 ай бұрын
Hi! Fist thanks for the great video I followed the steps but it keeps giving my negative value in worked hours because i work night shift, how to fix that? Thx
@Willhelm55
2 жыл бұрын
Thank you so much! This was very helpful!! :D
@angelaramirez9823
11 ай бұрын
Super helpful, thank you!
@yuanwang446
3 жыл бұрын
Hey, Sir, I keept got value error in the total hours worked. When I use (C2-B2). How can I fix that? Thanks
@xionkale3688
Жыл бұрын
the Dad jokes gave me cancer... i can tell you are good with Excel.
@bikotheanimator6169
2 жыл бұрын
Excellent tutorial, but one thing I don't see anywhere is how to incorporate lunch time into formulas. It is sort of useless with it. Unless I am wrong.
@crocodileman5811
3 жыл бұрын
YOU ARE A STAR
@tammykrack5337
5 жыл бұрын
Hello, I found your instructions very helpful and easy to follow along. I would like to make an adjustment to the total hours worked. Instead of calculating by the minute I want to convert minutes to tenths of an hour. Can you help me re-formulate my spreadsheet or send me a video on how to do this. Thank you Tammy
@playlist1187
2 жыл бұрын
Hi There, Your training is very user friendly and very accurate. Thank you Octavio. PS. I do have a question: How do you set the cells for straight time and after 8.0 reg. hour if becomes time and a half. then afetr 12.0 worked hours double. Please let me know
@eallen5562
Жыл бұрын
I'm excluding weekends in the 15 days or 3 weeks before follow-up using the 15,("0000011") formula, but I can't formulate the cells without it copying what's in the cell down the column.
@kshyne
5 ай бұрын
Amazing!
@williamcloonan7124
6 жыл бұрын
Your video is good...thank you. However I am unable to complete the formula for Hours Worked, I am continually receiving an error message. I am inputing the formula as described however I keep receiving the word "value" instead of a number.
@tomrussell8803
8 ай бұрын
your going so quick its impossible to understand what your doing when we've never done this before
@tis7046
6 жыл бұрын
You have skipped so many steps. I thought this is a "TUTORIAL".
@melindaburnside1835
2 жыл бұрын
2 THUMB'S UP 👍👍
@chinuahmed9865
2 жыл бұрын
I really loved they way you explained things. I created a same worksheet and followed your instructions but I got stuck in the gross pay column. Once I copy and paste formula after doing the first amount
@chinuahmed9865
2 жыл бұрын
Row down show 0 which is fine but after that SHOWS #VALUE! and next one copy the same amount as first gross pay. Please let me know why
@brizeydamendoza5347
2 жыл бұрын
Sos otro pedo loko!!! Lo aprendi al 100
@sithembisomabele8881
2 жыл бұрын
hi i enjoyed this can you help how to calculate for Sundays and holidays
@sureshbabusuresh5723
6 жыл бұрын
very very good video sir
@mosheb3674
4 жыл бұрын
How can you insert a 24 hour period for example if i worked from 7:00 Am to 7:00 Am ? it shows up as 0:00
@lettynavazquez5764
4 жыл бұрын
Your classes are great! i love it. Is there a way to filter between times? Say for instance, I have a courier team who drives medical supplies back and forth all day. So we have 1st shift, 2nd shift, 3rd shift, overnight and weekend shift. I have 6 months worth of data and i was trying to see overnight shift only. So i wanted to filter it to where i only see routes picking up items from 10:30pm to 7:00am. Is this possible? do you have a tutorial on how to do that if it is possible? Please advise. :)
Nervously laughing @ 1:05. Oops, shall I prepare for my beating?! Haha... My horrible childhood shall NOT interfere with me learning a simple equation protocol for a timesheet about counting trains. May we please continue? ..."it's never gross to get paid"... Is this guy an A.I. of every comedian Ever? I can't learn if I'm laughing too much. I might earn a 1:C
@natalie1148
4 жыл бұрын
How can you add lunch break to the time sheet in Excel?
@jeremyo1073
3 жыл бұрын
Jeremy O 1 second ago type this in the total hours cell =IF(B2"",(C2-B2)*24-0.5) the .5 is the half hour break. it is what i was lookink for today
@Chris_Pars0ns07
5 ай бұрын
Total Hours worked formula is being funny with me even when I *24 I am in the UK and use the 24 hour time frame would this impact it at all?
@KarlHeinzofWpg
Жыл бұрын
Wonderful. Thank you!
@2002Jaydub
9 ай бұрын
I have a question. Would this be feasible for my Jr’s & Sr’s in High School so we can keep up with their time?
@chefkhal
3 жыл бұрын
How do you calculate the total hours per month or weeks? because after 24 hours it show 16 if you worked 40 hours !!
@rotitnhoj
5 жыл бұрын
nice and simple instructions! thank you
@mr.hamster7722
5 жыл бұрын
Generally it is a very good video. Thank you.
@kamleshrathodsupportingpeople
4 жыл бұрын
Thanks for your tutorial, namaste!
@mdashrafulalamshahriar3587
Жыл бұрын
this one is helpful. my shift starts at PM and sometimes ends at AM. e.g 4:30 PM and finish at 12:50 AM. so in this case how to calculate this? using your formula it is not showing the exact working hours
@gb6003
3 жыл бұрын
Thank you, Colin Robinson!
@AesanPulass
2 жыл бұрын
Very nice work can you do something with more than 1 worker each one with a different pay
@patriciaontiveros7602
4 жыл бұрын
Lunch break. do I add in another column and name them time in and time out ? and or is their a formula?
@user-yn1ki4by2d
5 ай бұрын
I used this video to create a time clock tracker to manage attendance. The problem I came across is when I deleted the time in and time out for a new week, the total hours worked field populates "-0.50". this is a problem for me because if someone takes a day off during the week, that days hours will be negative when it should be zero. Their total hours for the week will also include this negative. What format needs to be inputted to removed the negative if no value is there?
@augustinhenry2606
3 жыл бұрын
Super video
@ranolsir
5 жыл бұрын
It was very good teaching. How about on iPad or iMac , do you have similar features? Because I use Apple to work all . Thanks for your video & teaching.
@camman61
5 жыл бұрын
Great information But looks like you left some steps out to format cells. I watched the beginning after a few times and yes they were steps not show. But very good information for us beginners
@SMAWPC1
4 жыл бұрын
Need to slow down and actually show each step you do
@vdinfante
3 жыл бұрын
Thank you so very much for your tutorials. Do you have information that you might recommend for someone serving as a Shipping/Receiving Supervisor?.
@nokpiadariusconstantino1333
2 жыл бұрын
Оыбовьщцбвл ьвовбтужцдзцхцххцхдвшуощкьин. А. Воцдткткщдклп
@mynameisneb
2 жыл бұрын
Excellent Video! I really just needed to keep track of my own overtime in an easy way! However is there a way I can calculate my gross pay with shift differential? Say I make an extra $1.15 per hour from 3pm-11pm and $1.25 from 11pm-7am. Just seeing if there was a way to make excel calculate this just based off of my time entries
@yasminnur1827
Жыл бұрын
You would need adding columns , shift 1 and shift 2 and set two gross rates and just add rate 1 and rate 2 in the total gross pay. (hours x rate1) + (hours x rate2), something like that
@ismokeu2
4 жыл бұрын
Thank you for tutorial, Someone mentioned below a problem I was having. " When I’m doing the equation like you are at 4:42 mine says value after I enter how do I fix that? The fix is to be sure to have a space before the AM & PM; Credit Jenna Mattox for that..
@nokpiadariusconstantino1333
2 жыл бұрын
Рць уьщзудовьокт
@alicegrey727
3 жыл бұрын
THANK YOU! VERY HELPFUL
@SKS_Automobile
5 жыл бұрын
You are awesome man
@KGSGames
2 жыл бұрын
Thanks for this!
@eallen5562
Жыл бұрын
N All good, but my cells keeps copying the the first cell. How do I stop this? Also, I'm trying to create a column for today's date and another column 3 weeks or 15 days to schedule follow-up. How can I accomplish this?
@jemimahsawdagar9080
2 жыл бұрын
after I did the front row freeze the division between the box was gone how you a divider between those?
@melvingaldamez1464
Жыл бұрын
This perfect thank you
@Moogatoo
Жыл бұрын
What should the formula look like for hours worked until after midnight?
@armandomena3862
3 жыл бұрын
Thanks for help sir.
@cdtrailer
4 ай бұрын
how did you put back the line column on the header?
@KellyLovesCamping
Жыл бұрын
I need another column that adds over time rates and calculates tax payable from fortnightly pay cycles. Do you have anything?
@olgaamaro201
6 жыл бұрын
Freakin awesome!! Thank you so much! The only down side.. Is I only make $12 an hour. Not even close to 35😥 lol. I am glad i have found excel though and am trying to use it for a possible career. Since I didn't finish highschool 😔. Anyways thanks!
Пікірлер: 332