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
<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>