I am a relative beginner with excel and would appreciate in assistance with
the following problem.

The following data from personnel timesheets is contained in the cells

A B C D E F G H
1 $15 per hour Mon Tue W ed Thu Fri Sat Sun
2 Total Hours / Day 15 3 18 1 5 9 3
3 Normal Hours
4 Hours x 1.5
5 Hours x 2
6 Rate per day
Monday to Friday
For the first 7.5 hours the rate per hour applies
For the next 4 hours the rate per hour is multiplied by 1.5
For the next 12 hours the rate per hour is multiplied by 2

Saturday
For all hours the rate per hour is multiplied by 1.5 (cells G3:G6)

Sunday
For all hours the rate per hour is multiplied by 2 (cells H3:H6)

The number of hours worked at each rate may vary from 0.25 hour upwards.

The total hours per day will be inputted in cells B2:H2. From the total
hours per day
Require the spreadsheet to calculate the number of hours of
1) normal time and put in cell B3.
2) normal time x 1.5 and put in cell B4.
3) normal time x 2 and put in cell B5.
4) The rate per day to be calculated in cell B6.

Many thanks for any assistance that you can provide.