Impresionada con la buena calidad de las clases, ojala todos los cursos por internet que, incluso se pagan fueran tan buenos, y tan explicitos. gracias.
Hello, thanks so much for your clear lessons. However, I wonder why when I copy and paste the IF formular of over time hours for Jan 1 to Jan 8, all the figures are 0. they don't change according to the hour worked. Is there any particular configuration? Thanks
Excellent class. I just have a question regarding the overtime. for the first person Jon kern; he makes $15.90 per hour, but for the overtime you are paying him $7.95. If this is an overtime hour, the amount should be higher, right? the formula you use has 0.5*... My question is if the number should be 1.5 instead of 0.5? Thank you
Thank you for your videos. Those are very clear and easy to follow, but i have one concern here. the sample data are up to Jan 29. how about to calculate until Jan 31? I suppose =D4+7 formula is inapplicable in that case. Please explain me.
Oh, i found the mistake. I inserted the empty columns before Jan 1, such that the figures didn;t correspond to Jan 8. So I deleted the figures and repeated the if formula, then copied and pasted, and it worked!
Oh my God, it's getting difficult!!!! Lesson 1 and 2, I can take those but Lesson 3 is oh no! I want to have different assignments of this everyday for me to really absorb all.
@@zariagenevieve4741 I tried it as well. I could have add those months and hour payments, but I couldn't do it all at ones. I did it 1 week to the next week till week 5. But the end, I couldn't do what he did
People who use Excel for their job. Relative and absolute references are pretty common way to make formulas but difficult to understand the first time you see them.
Thank you Professor! May the Lord continues blessing you and family.
I just want to start by saying, THANK YOU!! This is so informative, and you make it so easy to learn.
I just love your teachings . you are very clear with your teachings. thank you God bless you more
love this and thanks - could you please continue with how to add cells to figure taxes and social security with-holdings?
You are simply the best!!!!!! Thank you so much!
Impresionada con la buena calidad de las clases, ojala todos los cursos por internet que, incluso se pagan fueran tan buenos, y tan explicitos. gracias.
Hello, thanks so much for your clear lessons. However, I wonder why when I copy and paste the IF formular of over time hours for Jan 1 to Jan 8, all the figures are 0. they don't change according to the hour worked. Is there any particular configuration? Thanks
thank u for these they're honestly very helpful
Thank you very much
ThankYou so much Professor!
How can I get payslips from this
Thank you
can you show us how to do paycheck for each employees showing tax and medicare and social security
Excellent class.
I just have a question regarding the overtime.
for the first person Jon kern; he makes $15.90 per hour, but for the overtime you are paying him $7.95.
If this is an overtime hour, the amount should be higher, right?
the formula you use has 0.5*... My question is if the number should be 1.5 instead of 0.5?
Thank you
The overtime bonus is 50% of his regular pay. This is added to his regular hourly pay.
Could You upload with MedcareTax,social tax, income Tax...
Thank you for your videos. Those are very clear and easy to follow, but i have one concern here. the sample data are up to Jan 29. how about to calculate until Jan 31? I suppose =D4+7 formula is inapplicable in that case. Please explain me.
Do you have a sample of DTR computation for lates and undertime in shifting schedule
Thank you for the tutorials!
could you help me sir? why is it when i tried to do the formula for dates its repeating itself like june 1 ..E5+7
Nice job. Please keep it up. God bless you more.
Oh, i found the mistake. I inserted the empty columns before Jan 1, such that the figures didn;t correspond to Jan 8. So I deleted the figures and repeated the if formula, then copied and pasted, and it worked!
Very helpful
First of all I 'd thank you for your great effort, but I'd be grateful if you could upload the excel sheet that you're working on
Great job! Just that the video focus isn’t sharp; most of the characters in your worksheet are blurry.
Great job!
Thanks for the visit
Thanks for Uploading such informative video
So amazing
Thank you, you're a great help
Oh my God, it's getting difficult!!!! Lesson 1 and 2, I can take those but Lesson 3 is oh no! I want to have different assignments of this everyday for me to really absorb all.
I said the same thing. He completely lost me halfway through Part 3.
@@zariagenevieve4741 I tried it as well. I could have add those months and hour payments, but I couldn't do it all at ones. I did it 1 week to the next week till week 5. But the end, I couldn't do what he did
Thank you!!!!!!
Thank you. this helps a lot!!!!
this is great,thank you
Thank you!
We have 5 shifts per day and an increment of 10 minutes each shift.
thank you for your help
Thank you sir
who the hell searches this up intentionally!!!!!
People who use Excel for their job. Relative and absolute references are pretty common way to make formulas but difficult to understand the first time you see them.
me
I did and its been really helpfull