Very helpful. I pay my employees by the minute, this guide made it 20x times faster. Thanks alot!!
@599CD
2 жыл бұрын
By the minute? Wow. :)
@kekeke4077
3 жыл бұрын
Thank you for the helpful video😊😊
@599CD
3 жыл бұрын
My pleasure 😊
@aaronmichael276
8 жыл бұрын
FANTASTIC TUTORIAL!!!!! You helped me understand "how" IF works. Thank you.
@599CD
3 жыл бұрын
You're welcome
@jaimegonzalez3032
Жыл бұрын
Thank you for the help!!
@599CD
Жыл бұрын
Welcome
@Chuchiross
4 жыл бұрын
Great Video THANK YOU!!! Your a great !! So happy I found you I was going crazy.
@599CD
4 жыл бұрын
Glad I could help!
@iTurk13
7 жыл бұрын
Thank you for the help! Explained a lot and done very well.
@599CD
3 жыл бұрын
You're very welcome.
@ItalianCarryout
9 жыл бұрын
Very Helpful! Thank you!
@599CD
2 жыл бұрын
Welcome. Where's my pizza? :)
@saranyams7443
5 жыл бұрын
Nicely explained 👍👍👌
@599CD
3 жыл бұрын
My pleasure.
@derina.maleek9408
4 жыл бұрын
thanks
@599CD
3 жыл бұрын
Welcome
@sashikakrishpeiris1228
11 жыл бұрын
Dear Sir, Your video is very helpful, Please advise me of a formula to use when calculating Over time hrs, If an employee has not signed out ( mistakenly ) that particular cell will show a Zero value, hence I would like to have a Zero value as the answer. Create a formula best fits this calculation. Many thanks ,
@codywogan3332
7 жыл бұрын
thanks man that really helped a lot
@599CD
3 жыл бұрын
You're very welcome.
@599CD
11 жыл бұрын
This should work on ALL versions of Excel. It's just simple math.
@599CD
11 жыл бұрын
The 1.5 assumes that overtime pays "time-and-a-half" so if you normally earn $10 per hour, your overtime hours are worth $15.
@essieparks1703
25 күн бұрын
thx
@kellyoku
4 жыл бұрын
This was amazing. Thanks a million. But, you did not explain how you got the Normal to appear in the cells of calculation. Please, Help.
@599CD
4 жыл бұрын
Sure I did. I showed you the calculation and then I used AutoFill to pull it down the rest of the rows.
@AMELIAEMOGIRL
13 жыл бұрын
thus us amazing ...thank u .merci !!!!!!!!!
@Josephkashimbaya
Жыл бұрын
Just what I wanted. How do you add the if function as a total of normal hours in a month
@599CD
Жыл бұрын
599cd.com/ask
@shridandakar
13 жыл бұрын
Hi sir this is shridhar ( it is very nice thanku..
@bigmama4293
9 жыл бұрын
Thanks so much. Teach!
@599CD
2 жыл бұрын
My pleasure
@hennessy195
5 жыл бұрын
when formatting a time sheet or invoice with like what you did in this video and the pay rate is different from Monday to Friday normal rate, for example for Saturday (time and a Half), Sunday (Double Time), and Holidays (Double Time), but you still want to calculate 1-40 hours as Normal rate, 41-50 hours as Time and a Half and 51 hours and above as Double time. can you make a video on how would I formulate that on Excel?
@599CD
3 жыл бұрын
Feel free to submit this at 599cd.com/TH
@annajaneturing9131
11 жыл бұрын
great thanks.....
@Sur5_lb988
4 жыл бұрын
I need to know how to enter a formula that will calculate total time with OT and vacation/holiday pay. For example: Person is paid biweekly. Week 1, works 42 hours. Week 2, works 38.5 hours and uses 4 hours vacation time. Their total hours should be 78.5 hours regular time, 2 hours OT and 4 hours vacation. So 82.5 hours paid at regular time rate and 2 hours paid at OT rate. I can't figure out how to have the spreadsheet only calculate the OT hours based off of 2 hours and not include the additional 2.5 vacation time at OT rate. Can you help??
@599CD
4 жыл бұрын
That shouldn't be too hard to calculate. Send it to me on my TechHelp page and I'll try to cover it. 599cd.com/TechHelp
@futuresuperstar4life
4 жыл бұрын
Can I calculate weekly overtime if I have all data in the same table/sheet as opposed to only calculating for a week and needing a whole new table/sheet as the week goes.
@599CD
3 жыл бұрын
You SHOULD have all of your data in the same sheet.
@georgigeorgiev4871
9 жыл бұрын
=IF(D2>=Normal,IF(D2
@599CD
9 жыл бұрын
Georgi Georgiev I often prefer using multiple columns and hiding them because it makes it easier to find problems, and to modify the formula later (not to mention explaining to other people how you arrived at that formula).
@georgigeorgiev4871
9 жыл бұрын
I get that. The only problem is, that when you have many columns it consumes more memory. But i guess this should be an advanced topic, so I'm sorry for bringing it up. Keep up the good work! Thanks for the videos!
@yvonneluyt7449
Жыл бұрын
I am getting an error on my overtime IF Function.
@HarlemFinest212
10 жыл бұрын
I have a question, how does this method also work if you get paid bi-weekly? lets say I worked 35 hours in one week and 50 hours in the next? (35 + 50)= 85hours. I guess I'm suppose to get paid 10 hours OT from those 50. Correct? However, I've seen employers add up both weeks like this and when you get your paycheck, you only get paid 5 hours OT instead of 10 hours. Is that legal?
@599CD
10 жыл бұрын
HarlemFinest212 I can't say what's legal in your area. Consult an attorney. Every state has different OT laws.
@user-mt4zr5kp7h
3 жыл бұрын
Ok, but what about this. So, I'm union. I get OT after 9 hours, daily, rather than after 45 hours in a week. so I can work 35 hours and still get OT that week. I'm looking to set up a sheet where I can input my hours at the end of each day and it will autofill the fields accordingly. I don't need fields for start and end times, just hours worked, much like your own spreadsheet but just for myself. So, I'll input my hours worked each day, Monday to Saturday. say, 9.5, 9, 10, 4, 8.5, 0 respectively. reg rate we'll say is 25, and OT is time and a half. As you can see, I'll collect OT for 2 of the 5 days. I'm having difficulty figuring out how to show regular hours worked, OT hours worked, and gross pay based on that information. PLEASE HELP while I still have hair left lol
@599CD
3 жыл бұрын
Interesting problem. Feel free to submit it here: 599cd.com/TH
@HaroonKhan-2317
8 жыл бұрын
sir you change in the below normal time half time and double time how we apply this i did not understand please teach me sir that you change in the hours it will automatically change in the above table how teach me sir
@599CD
2 жыл бұрын
Huh?
@TheLipton19
11 жыл бұрын
I dont understand with *1.5 .. How did u get that :( '=(B2*J2)+(B2*L2*1.5)+(B2*M2*2)* Please teach me ...
Пікірлер: 57