Transfer and subtract values from column A through C, whilst checking for greater than, equal to and less than.

[MagicBullet]

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[TABLE="width: 500"]
<tbody>[TR]
[TD]Total Hours
[/TD]
[TD]Total hours at 50% extra salary
[/TD]
[TD]Total hours at 100% extra salary
[/TD]
[/TR]
[TR]
[TD]2,20
[/TD]
[TD]2,20
[/TD]
[TD]0,00
[/TD]
[/TR]
[TR]
[TD]6,80
[/TD]
[TD]3,00
[/TD]
[TD]3,80
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Andrew Poulsom]

Welcome to MrExcel.

In B2:

=MIN(3,A2)

and in C2:

=MAX(0,A2-3)

 

[MagicBullet]

Hello Andrew. Thanks a lot for the rapid and correct response. Can't believe how simple the formula was A warm welcome I must say. I am very happy. Best regards, Daniel