MagicBullet
New Member
- Joined
- Dec 10, 2013
- Messages
- 2
Hello. I have an excel sheet where I have a column(A) with hours, displayed in decimals e.g. 2,2 hours. I need a formula which can check whether the amount is less than or equal 3,00 and if so just transfer the cell value from column(A) to column(B). If the amount is greater than 3,00, it just has to transfer the value 3,00. I then need to transfer the cell value subtracted by 3,00 from column(A) to column (C), IF the cell value in column (A) is above 3,00 and otherwise leave it blank(or display 0,00 as value). I have made a simple table to display the output I'm looking for. In short I need to calculate how many hours to be paid as 50% extra (the first 3 hours of the shift), and how many hours to be paid as 100%(the remaining hours of the shift). I'm a total excel noob when it comes to formulas, and I don't have anyone who can help me at my disposal, so I really hope some of you experts can help me out here
Looking forward to some possible solutions. /Daniel
<tbody>
</tbody>
Total Hours | Total hours at 50% extra salary | Total hours at 100% extra salary |
2,20 | 2,20 | 0,00 |
6,80 | 3,00 | 3,80 |
<tbody>
</tbody>
Last edited: