I need Help with an excel formula?!?

Question

I need to create a formula that will separate overtime worked if any per day can anyone help?

Answer 1

The problem is that you are entering hours worked as a 'time' value, like 8:40 AM.  If you are preparing a time card, then the usual method is to have a 'time in' and a 'time out'.  Then you can subtract the two 'time' values to get an hours:mins value.

Enter 7:00 in cell H9 and 15:30 in cell I9

In cell J9 enter the formula  =(I9-H9)*24

In cell K9 enter the formula =IF(J9<=8,0,J9-8)

You will see that in J9 you have the total hours worked in a format that can be used for computation, like hours x wages.

In K9, you will have the hours of overtime worked.

Answer 2

only on reward basis "per line per hour basis"