extra hours adding money for each extra hour worked FORMULA

Hi, can someone help me? I need to calculate this: for every extra hour worked, I pay 8 dollars. Not on minutes but only on whole hours. So if a person wored 2 hours and 19 minutes I pay the 19 minutes at a regular extra hour rate and the 2 hours I need to add extra 8 dollars to each hours. Does it make sense? how can I calculate that? PLEASE! Im driving myself mad!
Thanks

Sounds like you want HOURS(), which takes a time value, and returns an integer value for the length of the value in hours (it truncates). Note that going over 24 hours requires subtlety.

There is a similar function that delivers the integer of MINUTES().

Anyway, I think you want something like

Please Login or Register  to view this content.

C1 will multiply the hours worked (rounded up) by the pay rate; for your example of 2:19 then it would be 3 * 8 = $24.
Anyway you can change that 0 to like 15 or 10 or 30 depending on where the cut-off is for switching hours. Paying fractions of an hour would not be difficult either.

Hours Norma Extra Total
2:19 5 8 £12.53

In D1
=HOUR(A2)*B2+(C2/60) *MINUTE(A2)

Thank you. It worked! now I have another I need to add 10 minutes to every hour worked. So If they worked 5 extra hours and 40 minutes. I need to add 50 minutes to the 5 hours and 40 minutes. but I dont know how to format the cells... cause if i choose time then it multiplies the hours times the minutes as if the minutes were hours so i dont know how to do it. any ideas?