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
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.
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.
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.
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
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
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!
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. :)
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
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
check this video for more. like and subscribe. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-1abjBrSqTnk.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
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
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.
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.
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
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?
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?
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
What if I wanted to rounded up the hour worked? For example clock in at 3:43PM, Clock out at 7:00PM. The employee supposedly start working at 4PM as the salary started counting at that time.
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)
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.
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.
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.