Need help creating a conditional formula

[dykstjan]

I am trying to create a formula that will calculate a formula one way if a cell has a value of "P" and a different way if the cell has a value of "U". The formula is in a time sheet. If lunch hour is 'P", then it should not subtract the value. If it is "U" it should subtract the value. The formula in Column G is (H1-C1)*24 -F1. Thank you for your help

C Starting Time D Lunch Start E Lunch End F Lunch Hour G Paid (P) Unpaid (U) H Ending Time I Regular Hours Worked 8:00 AM 12:00 PM 12:30 PM 0.5 U 4:00 PM 7.5 <colgroup><col><col span="2"><col><col><col><col></colgroup><tbody> </tbody> <colgroup><col><col span="2"><col><col><col><col></colgroup><tbody> </tbody>

<colgroup><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>

 

[dcofer]

You are welcome. Glad it worked for you.

David