"IF" formula problem

[excelbeginner2]

Hi I've looked on a couple of threads already and tried to adapt my formula using them but I'm a bit of a novice and need some help, please!

I am making a basic table which calculates wages depending upon hours worked, at the moment the user inputs a start time and end, a job role/wage and this calculates a total £ sum. However, in addition for this I wish for the total to be multiplied by 1.5 (*1.5) if the hours worked were on a Saturday to signify time and a half paid when employees work on this day, this is in another column.

I hope that's pretty clear for my first post, thanks in advance for your help!

 

[mick0005]

Here you go. I don't know the columns/rows of your setup so I had to create a table on my own from scratch. In the future I'd recommend that you use the HTML Maker (see my signature) to do this for the forum members. It will save everyone time and will make people more likely to attempt to solve your problem.

My solution relies on the assumption that you have the date somewhere for each record, column A for my example.

Excel 2010

	A	B	C	D	E	F	G

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #B8CCE4, align: center"]Date[/TD]
[TD="bgcolor: #B8CCE4, align: center"]In time[/TD]
[TD="bgcolor: #B8CCE4, align: center"]Out time[/TD]
[TD="bgcolor: #B8CCE4, align: center"]Wage[/TD]
[TD="bgcolor: #B8CCE4, align: right"][/TD]
[TD="bgcolor: #B8CCE4, align: center"]Hours Worked[/TD]
[TD="bgcolor: #B8CCE4, align: center"]Pay[/TD]

[TD="align: center"]2[/TD]
[TD="align: center"]6/11/2015[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:00 PM[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]120[/TD]

[TD="align: center"]3[/TD]
[TD="align: center"]6/12/2015[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:00 PM[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]120[/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]6/13/2015[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:00 PM[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]180[/TD]

[TD="align: center"]5[/TD]
[TD="align: center"]6/14/2015[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:00 PM[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]120[/TD]

[TD="align: center"]6[/TD]
[TD="align: center"]6/15/2015[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:00 PM[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]120[/TD]

[TD="align: center"]7[/TD]
[TD="align: center"]6/16/2015[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:00 PM[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]120[/TD]

[TD="align: center"]8[/TD]
[TD="align: center"]6/17/2015[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:00 PM[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]120[/TD]

[TD="align: center"]9[/TD]
[TD="align: center"]6/18/2015[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:00 PM[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]120[/TD]

[TD="align: center"]10[/TD]
[TD="align: center"]6/19/2015[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:00 PM[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]120[/TD]

[TD="align: center"]11[/TD]
[TD="align: center"]6/20/2015[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:00 PM[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]180[/TD]

[TD="align: center"]12[/TD]
[TD="align: center"]6/21/2015[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:00 PM[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]120[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F2[/TH]
[TD="align: left"]=(MOD(C2-B2,1))*24[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]G2[/TH]
[TD="align: left"]=IF(TEXT(A2,"ddd")="Sat",(F2*D2)*1.5,F2*D2)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[excelbeginner2]

Thank you very much Mick!