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!!

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)