# Formula for overtime rate

1. ## Formula for overtime rate

* I need help on the "EDIT" part. I posted a thread about the first problem yesterday and saved it as SOLVED already. But I had another connecting problem, so I figured it'd be best to quote my previous situation to understand my current question better. Let's say for example I have a work overtime of 1 hour and 15 minutes (1:15). For each overtime hour, the rate is \$66.56, and for each overtime minute, the rate is \$1.10 (The price is bit high because I'm using the value for my country, not the dollar rate).

In this case, the solution would be (# of hours x 66.56) + (# of minutes x 1.1) = overtime pay. Thus, (1 x 66.56) + (15 x 1.1) = 83.06 (the overtime pay that I would be receiving).

Is it possible to encode a formula in excel in this way? That if I input the hours and minutes of overtime, the specific cell would automatically solve like this?

I hope someone can help me! Thank you!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

EDIT: (I need help on this part)

If I am absent on a specific day, I obviously wouldn't have any overtime. How do I add the IF FUNCTION in the formula << =HOUR(A1)*66.56+MINUTE(A1)*1.1 >> ?

If I just leave it blank, it would just show an error: #NUM!  Register To Reply

2. ## Re: Formula for overtime rate

Maybe
=IF(A1=0,"",HOUR(A1)*66.56+MINUTE(A1)*1.1)  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 