IF Formulas

[mizzamzz]

Hi All!!



Firstly let me just say this forum is AWESOME! What a fab idea!!!

I was hoping someone may be able to help me with a particular IF formula?

It's for a time sheet and what I would ideally like to do is work apply time and a half to any hours worked outside 8am-8pm. How can I do this?

For example how would I do a formula to populate cell C in the below?

Start Time(Cell A) Finish Time (Cell B) Overtime Hours (Cell C)

06:30 21:45

I need to do something along the lines of: If Cell A is less than 8am then the hours less than 8am need to be multiplied by .5 (as the total number of hours is cell C will be added to my total hours for the week in another formula which I already have in place). Then if Cell B is greater than 20:00 then the hours greater than this need to be multiplied by .5 also.

Is this asking too much? Can this even be done?

Any help would be HUGELY appreciated!!

[mugezhn]

Try this

Write 08:00 in Cell D and 20:00 in Cell E.

Apply the following formula in Cell C:

=IF(A2<D2;(D2-A2)*0,5;0)+IF(B2>E2;(B2-E2)*0,5;0)

(Assuming that you use Row 2)