Hi, am trying to finalise a time sheet and can't figure out how to make it
"automatic". Here's what I'm trying to achieve:
In F5 I have "Total hours worked"
I'd like to take the figure at F5 and automatically split it into the
following:

"On Weekdays"

H5 - Ordinary time (a maximum of 8 hours)
I5 - Time and a half (a maximum of 3 hours)
J5 - Double time (any hours worked after both the above)

"On Weekends"

I10 - Time and a half (1st 3 hours, they are paid a minimum of 3 hours)
J10 - Double time (after 1st 3 hours)

Many thanks
Andy