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!
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!
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
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!
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 :)))
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
I have my time sheet in military time (time in 08:30:00 time out 15:30:00 total hours worked 07:00) how do I format the cell to calculate the full column of total hours worked?
Is it possible to show an example with non exact hours with different amounts of minutes. ex 8:50am in 2:00pm out I do this and I get 5:17. which is wrong. it should read 5:10 min. what am I doing wrong. Thanks.
check this video for more. like and subscribe. ua-cam.com/video/1abjBrSqTnk/v-deo.html 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
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!
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.
How can i make an excel for individuals so that i can say each individual gets 45 mins and we start at 13:00 and it will tell you ok so person 1 starts at 1300 and ends 1345 and goes to the second person and says he starts at 1345 and ends at 1415 and so on and so forth.
Hello sir. thanks a million for this info. How do we calculate short shift worked, like e.g. if an employee has to work 8 hour shift then they work 6 hours and 20 minutes, is there a way in which you can provide a formula that automatically calculate hours short to make 8 ours.
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!
Make sure there is a space before the "AM" or "PM" in the times columns. That was causing me issues until I found another tutorial with common mistakes
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..
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.
how did you fit all those words inside the box? and the box automatically adjust its size to fit those words? please help. every time i put words on those each box it goes through the next column.
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
Thank you so much! I have one problem; one day i worked over midnight, and the sum is in minus. How do i fix this? Also, does anyone know how to open it in google spreadsheets with the formating? Doesnt seem like it works.
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
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.
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. :)
If I'm trying to make this a project time sheet and there are multiple time entries for the same date, how do I create a table that will total each day individually?
This Timesheet is flawed because I have entered the formula as you instruct - however - it does not take into account split shifts and also try putting the time in at 9:00Pm and Timeout at 4:00AM. the figures go into the minus. (unless I'm doing something wrong). Some people work more than one shift per day and they also work unsocial hours too. Please, can you tell us what the fix is for this???
@@makenzishackley1882 - No, never did. And putting the space between the AM and PM still doesn't cure it. Will have to go back and double check everything, because in riciple, the time sheet is actually quite good if I can get this one single aspect to work. Timothy Makgoro, Any suggestions??
@MaKenzi Shackley - Here is the answer you're looking for. If your employees work unsocial hours, i.e start in the evening and finish the following morning, enter the following formula in total hours. Later time/Earlier Time means excel box containing the later time and earlier time =MOD(Later Time-Earlier time,1)*24 or longhand =MOD open-bracket Later Time minus Earlier Time comma 1 end bracket multiply by 24 After the formula is entered, then select the total hours and press CTRL+Shift+~ if the total hours shows decimal numbers.
to fix that error you have to enter the time in 24hour format like if time in is 7:00am and time out is 17:00 (5:00pm) hope you can understand if not let me know thanks
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
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
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?
how do i set up a laps time? like i wanna see how many hours i was fasting between my meals?? so i enter my data date and time but how can i see how many hours was between
By creating a separate column where you can put the hourly rate in for each employee. You'd have to put the formula in the top column only and then drag down so that it calculates and totals each employee's hours and rates :-)
What would be the formula to calculate number of hours for a time period spanning midnight such as 10pm to 6am? I used the IF function but the value is a percentage (ie 0.33 instead of 8)
I just want to add different periods of time without entering any time stamps. like I just want to add 5:39 to 15:40 and so on. how to do it because I cannot figure it out.
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!
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!
🎉😂
Haven't used Xcel since high school, this really helped refresh the memory. Thanks a lot!
🎉😅
One of the best trainers I've ever watched on UA-cam. Excellent video, easy to follow. Thank you!
This formula and instruction was totally worked for me. Thank you! :)
Ganbayvwjbaibqyqoozbajvakwbgwoiqoqoqivsyqivwkbw
Easily understand to me. Very simple way explained! Thank you boss
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
hi, I really like the way you teach, amazing, thanks from Afghanistan.
excellent, I was looking for this exact example!! very well and organized!! thank you so much!!
Виовтрутлуигдулоудлцдзцзхцзцзщцтвшао
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
Super simple and very easy to follow. Worked great!! Thank you
Great video! Explained very well.
Woww thank you, it helped me in 2024. Great job.
How do I calculate the break duration from their time in and time out
very helpful as i learning a new job. excel is going to be my best friend for the foreseeable future
Thanks! Super simple and easy to follow.
Bro this video helped me so much ...thanks bro ...
Dude! You are the man. This helps.
Great tutorial - straight to the point. Thanks
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
Excellent Presentation I followed along and created my own individual Time log. Thanks.
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. 😎✔
Втовб тььь щыблвю вдбкзххуххцжудьвщцдгудьзвблвбтабоажьвздвьзцлщцлщцлщузцдулщущ дзэ ьцлцдопьщпзькдджэыьоа бэ лвдьвдлущвззыжжцьвщулгуду
Thank you for these simple instructions, it worked perfectly.
thank you for sharing this,
this video is very helpful to me
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!
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
Thanks! indeed super simple and easy to follow...
Thanks buddy! This is fantastic.
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 :)))
Thank you so much for this tip!!!
Excellent! I was wondering!
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
This is exactly what I need thank you.
Thank you for this sheet. I really needed it. You have yourself a new subscriber.
You are wonderful. Thank you for
sharing this extremely helpful information.
I have my time sheet in military time (time in 08:30:00 time out 15:30:00 total hours worked 07:00) how do I format the cell to calculate the full column of total hours worked?
Thank you for the tutorial its very helpful.
wonderful tutorial it helped me make my first excel timesheet thanks
this helped wonderfully and I was even using Google sheets.
Is it possible to show an example with non exact hours with different amounts of minutes. ex 8:50am in 2:00pm out I do this and I get 5:17. which is wrong. it should read 5:10 min. what am I doing wrong. Thanks.
Absolutely the best.
Can you do one for Time difference.
Thank you for sharing, so that I can keep track for my business development progress.
check this video for more. like and subscribe. ua-cam.com/video/1abjBrSqTnk/v-deo.html
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
Thank you so much! This was very helpful!! :D
Realy nice and super
Thankyou Sir for your best advise and best learning
Super helpful, thank you!
Great Video. Do you have a video for working Overtime as well to be calculated into Total Paid Hours for the Day?
Hey, Sir, I keept got value error in the total hours worked. When I use (C2-B2). How can I fix that?
Thanks
hi i enjoyed this can you help how to calculate for Sundays and holidays
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!
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.
Then you would have to add the 30 minutes to the next day. That’s on every program.
Thank you soooo much! Easy to follow!
Hagqibaoba
How do you calculate the total hours per month or weeks? because after 24 hours it show 16 if you worked 40 hours !!
Lunch break. do I add in another column and name them time in and time out ? and or is their a formula?
How can i make an excel for individuals so that i can say each individual gets 45 mins and we start at 13:00 and it will tell you ok so person 1 starts at 1300 and ends 1345 and goes to the second person and says he starts at 1345 and ends at 1415 and so on and so forth.
Thank you you are awesome teacher
How can you add lunch break to the time sheet in Excel?
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
Hello sir. thanks a million for this info. How do we calculate short shift worked, like e.g. if an employee has to work 8 hour shift then they work 6 hours and 20 minutes, is there a way in which you can provide a formula that automatically calculate hours short to make 8 ours.
Trying to learn it from my phone maybe if you could explain it from an android
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!
how did you put back the line column on the header?
Very nice work can you do something with more than 1 worker each one with a different pay
When I’m doing the equation like you are at 4:42 mine says value after I enter how do I fix that?
Make sure there is a space before the "AM" or "PM" in the times columns. That was causing me issues until I found another tutorial with common mistakes
@@jennamattox9021 Thank you. This was driving me crazy and I couldn't figure it out.
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..
Рць уьщзудовьокт
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.
I created a time sheet following your formulas, but something is missing when i put in 11:44 pm to 12:29 am i get -23.25 hours. can you help me?
how did you fit all those words inside the box? and the box automatically adjust its size to fit those words? please help. every time i put words on those each box it goes through the next column.
Thank you so very much for your tutorials. Do you have information that you might recommend for someone serving as a Shipping/Receiving Supervisor?.
Оыбовьщцбвл ьвовбтужцдзцхцххцхдвшуощкьин. А. Воцдткткщдклп
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?
after I did the front row freeze the division between the box was gone how you a divider between those?
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
Thank you so much! I have one problem; one day i worked over midnight, and the sum is in minus. How do i fix this?
Also, does anyone know how to open it in google spreadsheets with the formating? Doesnt seem like it works.
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
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.
What should the formula look like for hours worked until after midnight?
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. :)
Вивовж двблаж ин ьвлзжухххциочтоаловхцххцххытшцлшузцжзцхцжвььлаьшужлвбтвщцдщцээцээцэ тььь шць шд лцзхцхыьтягвлшвзутшадлвбташвлшвзььввьшудив зы уждвхжцэцээцхузвщуьгкжпоьшклшкдцдуьзбцжцхцэдв ТтЛ вьиаь
Вь ужутшудоуьоуьовшушузлудгвдщудшузтцуьщузужххххцжтшаьнкорщуьпвьмвтощщуоишьцрцдиллиодивдоудддуаьщужщыждзцжла кд
How do you do overtime hours and how can I use my tablet when everything looks different
your going so quick its impossible to understand what your doing when we've never done this before
If I'm trying to make this a project time sheet and there are multiple time entries for the same date, how do I create a table that will total each day individually?
What the HELL did he do at 1:56? I am so frustrated. How are people getting these borders? None of my rows or columns have lines.
This Timesheet is flawed because I have entered the formula as you instruct - however - it does not take into account split shifts and also try putting the time in at 9:00Pm and Timeout at 4:00AM. the figures go into the minus. (unless I'm doing something wrong).
Some people work more than one shift per day and they also work unsocial hours too.
Please, can you tell us what the fix is for this???
put space between your time and the pm or am so excel can be able to calculate e.g 9:00 PM instead of 9:00PM
Did you ever figure out how to do this?
@@makenzishackley1882 - No, never did. And putting the space between the AM and PM still doesn't cure it. Will have to go back and double check everything, because in riciple, the time sheet is actually quite good if I can get this one single aspect to work. Timothy Makgoro, Any suggestions??
@MaKenzi Shackley - Here is the answer you're looking for. If your employees work unsocial hours, i.e start in the evening and finish the following morning, enter the following formula in total hours. Later time/Earlier Time means excel box containing the later time and earlier time
=MOD(Later Time-Earlier time,1)*24 or longhand =MOD open-bracket Later Time minus Earlier Time comma 1 end bracket multiply by 24
After the formula is entered, then select the total hours and press CTRL+Shift+~ if the total hours shows decimal numbers.
hope that makes sense
Another problem. How do you set the year in excel. Even formulating a column, the year is still reading 1900. Any advice?
Thanks for your tutorial, namaste!
Good day. How do you fix a value error in excel.I did everything in the video but getting an error still
to fix that error you have to enter the time in 24hour format
like if time in is 7:00am and time out is 17:00 (5:00pm)
hope you can understand if not let me know thanks
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
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
what if the excel was already in 24 system, do we need to apply the *24?
2 THUMB'S UP 👍👍
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?
How do you add lunches in there so that the total hours worked reflects that?
I need another column that adds over time rates and calculates tax payable from fortnightly pay cycles. Do you have anything?
Hi what if you work from 4:30 p. To 12 am
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?
how do i set up a laps time? like i wanna see how many hours i was fasting between my meals?? so i enter my data date and time but how can i see how many hours was between
Thank you for this excel spreadsheet! How do I deduct one hour lunch break?
Is there any other way to lock a formula than using the F4 button? The laptop I'm using doesn't seem to lock the formula using that button.
Can this be used for employees who are on salary as opposed to hourly? Or does this strictly just apply to those who are hourly?
yes you can but will make adjustments
how do you do this with say 5 or 10 employees that are paid different rates per hour?
At the bottom right click on the tab you are on and hit duplicate. Then rename each tab as each different employee. Then change the hourly rate total.
By creating a separate column where you can put the hourly rate in for each employee. You'd have to put the formula in the top column only and then drag down so that it calculates and totals each employee's hours and rates :-)
Wonderful. Thank you!
What would be the formula to calculate number of hours for a time period spanning midnight such as 10pm to 6am? I used the IF function but the value is a percentage (ie 0.33 instead of 8)
Hi, great video.. how would you handle unpaid break time?
I just want to add different periods of time without entering any time stamps. like I just want to add 5:39 to 15:40 and so on. how to do it because I cannot figure it out.
Hello there I was wondering if you can do a video of how to calculate biweekly hours work plus over time
You are awesome man
How do you get the dark lines?