I do have a special case when it comes to calculate overtime, I think.

The case is this:
Company rules says that you are not supposed to have any extra % for
overtime
before you have 37.5 hrs a week. Then, if you work overtime you get 50% and
if
you work moore than 4 hours overtime one day you get a double50 %. Say
one person works from 08:00 to 16:00 (minus 30 min. lunch) = 7.5 hrs regular
time. He then works overtime from 16:00 to 21:30 which makes 5.5 hrs
overtime.
This will give him 4 hours with 50% extra and 1.5 hrs with 100% extra.

But when a person works only 80% or 4 days, he first have to work 7,5 hrs
overtime
that week to have full time job. After that, overtime is rewarded with 50%
extra or
100% extra if moore than 4 hrs same day.

What I want formulas for is: 0% 50% 100%
0% is for overtime hours up to 37.5 hours a week, then 50% for additional
overtime
and so on.

For full time workers working 8.5 hours overtime:
WorkDate FromTime ToTime 0% 50% 100%
5/2/2007 16:00 21:30 0 4 1.5
5/2/2007 16:00 19:00 0 3 0

if part time (80%) this example should look like this:
WorkDate FromTime ToTime 0% 50% 100%
5/2/2007 16:00 21:30 5.5 0 0
5/2/2007 16:00 19:00 2 1 0

The formulas must be able to handle both examples in one solution if
possible.

Any good suggestions for good formulas is very much appreaciated!

Regards
Jan T.