Hello,
I'm looking for a formula that will multiply a value based on the time codes of Regular (no multiplier), Overtime (1.5 multiplier) and Premium(2 multiplier).
The download from our accounting software displays as follows:
<colgroup><col><col></colgroup><tbody>
</tbody>
Can an IF statement be developed for this?
Thank you,
Jen
I'm looking for a formula that will multiply a value based on the time codes of Regular (no multiplier), Overtime (1.5 multiplier) and Premium(2 multiplier).
The download from our accounting software displays as follows:
Type | Hours |
Regular | 0.50 |
Regular | 0.25 |
Regular | 0.50 |
<colgroup><col><col></colgroup><tbody>
</tbody>
Can an IF statement be developed for this?
Thank you,
Jen