G'day New to Excel

Here is the normal view you would see when all the formula's are in place:

A B C
D E F G
H

Row 1 Employee Employee Total
T1.0 T1.0 T1.5 T1.5
Gross
Row 2 Name Rate Hours
Hours $ Hours
$ $
Row 3 Jack 38.00 60.00
40.00 1,520.00 20
1,140.00 2,660.00
Row 4 Jill 29.00 60.00
40.00 1,160.00 20
870.00 2,030.00

And so on & on................

By the way, where does the Queue start to get a job at this company with
these hourly rates.....LOL.....:-)

Now for the formula's in each Cell: Starting @ D3

D3 =IF(A3="","",IF(C340,40,C3))
E3 =IF(A3="","",(D3*B3))
F3 =IF(A3="","",IF(C340,C3-D3))
G3 =IF(A3="","",(F3*B3)*1.5)
H3 =IF(A3="","",(E3+G3))

Copy and paste down as required

Now, this is where we get to the slighty harder stuff, particularly for
newbies, by that I mean, Name Ranges, Data Validation dropdown lists and
lookup tables to automate the sheet for you.

If you don't think you ready for all that, start entering the info in
manually until you get more familiar & comfortable using Excel and some of
it's functions.

Let me know if you're feeling up to the task and I will step you through the
other stuff.

Good luck
HTH
Mark.