IF Function to Calculate Overtime Pay in Excel

[Differentme091]

Thanks so much!!



[goldenforeverxo]

Thank you so much! Very clear explanations...More than I've learned from my professor who I actually pay to teach me.

[LoadedKlip]

Awesome videos. Thanks a ton.

[soumya1000]

This is a great video for calculating the overtime pay, its good Thanks for ur good video

[WizardRizzo]

Ralph, as an online instructor in Excel I am always on the lookout for nicely done video references on different calculation techniques. This is a very well done instructional video. Thank you.

[xomaexo77]

I would rather had you explained how to calculate the whole formula in one. I have to find commission as well as one employee's overtime pay. All in one would be best but this is good. I can make it work, I hope anyways. I have never used excel but have to do this for my final paper in my excel class. Not having good luck here. :( Thank you.

[xomaexo77]

I would rather had you explained how to calculate the whole formula in one. I have to find commission as well as one employee's overtime pay. All in one but this is good. I can make it work in my spreadsheet. Thank you.

[nazdsm]

yes simplified and well explained when using the if function this is great i so recommend, also gud showin another way using the minimum formula even though the main focus was using the if function.

[omgdidjaseethat]

THANK YOU!!!!!!!!!!!! YOU ARE A LIFE SAVER

[havz0r]

Many thanks sir! Great tutorials.

[dancechick0453]

simply put :) thank you

[Griffo008]

thank u sooooooomuch nigggggaaaaaaa

[bryseb90]

Thank you very much it help me a lot, I use for myself to track my work time, and i enjoyed following you, so you are my teacher now

TANKS

[geertdd]

The base pay formula can be simplified from:

=IF(E5>40,D5*40,D5*E5)

To this:

=MIN(40,E5)*D5

[rrphillips]

excellent! great idea.

[soldier501]

why do use =SUM(F5,G5,H5)... It's easier to use =SUM(F5:H5)

[anigz]

most MS Office tutorials are too small to see. yours is great.  thank you

[tombouctou01]

Hi , Really Great Video, very clear. What about the 2nd part of this video, I cannot find it!!!

Thanks

[cynthias777]

How does this work with just trying to figure out the OT hours? Will it work with hh,mm (hours and minutes instead of just whole hours? I need something that will just break out the ot time (minutes and/or hours) from reg time if there is OT. Thanks and hope you can help.

[SMOGGYLAND]

I think this is pretty good, but I wouldn't have used as many constants i.e 1.5 and 40 in your Functions. Instead, I would have made your column F header 'Base Pay Hours 40' That way you could have said, in F5 =if(E5>right($F$4,2), etc.... That way if the basic hours changes from 40 to say 42 you only have to change the 40 in F4 and not search for everything reference a 40 within your spreadsheet. The same idea could be used for the over time 1.5 as this could cahnge to double time.

[starhammad]

wonderful simply great work mite....thx very much for all videos......

[qawserftgyuh]

i should have just continued watching you..other tutorials made my brain fuzzy! ugh..

[balooZ]

great video a++

[mel9985]

Great Quality Video!

[ScarsdaleNewYork]

Thank you, rrphillips.

Your videos' instructors are knowledgeable and make leaning so simple.

Great graphic image too. Unlike others posted videos, their images are so blurry for anyone to see what is going on.

[vd32]

Excellent!!!!Thank you!!!!

[YTwatcher38]

I had to log in just to comment on your excellent videos. A visual example is worth 10 books.

[LizaP666]

I was trying to figure out of to calculate the overtime for a quiz next week and you've made it simple. Thank you! :)

[littlepitt2000]

You are a great teacher. you make Excel seem so easy. I appreciate your tutorials as they are helping me as a novice to learn Excel. Please continue to post new videos. Thanks

[ejmagidson]

My CIS131 class has a question? Is tirathmistry a student in your class looking for the grade of A? laughing.....joke.

[tirathmistry]

Wow another Awesome tutorial rrphillips !!

You are awesome tutor.

Nice example

Your all video tutorial are Awesome

I've learned so much from you THANK you so much for all your hard work, it has brought me immense joy, satisfaction and knowledge!

God bless you rrphillips

[ejmagidson]

RalphCo... laughing so hard....

Love the video!