* 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!
Thanks for your help!
Bookmarks