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