Calculate overtime in Excel

[novaislam]

Hello People!
I am working on an excel sheet which will calculate attendance, as well as overtime. Our policy is- if the overtime is less than an hour, we don't pay for it, if it is more, then the employee get paid.
Now I want something which will keep the value in column A, if it is less than an hour, and keep it on column B if the value is 60 minutes or above.
How can I do that?

 

[Momentman]

So i assume you have an overtime column (say Column C) and its in minutes

Then in column A you can use =IF(C2<60,C2/60,""), this will give the value in hours or simply =IF(C2<60,C2,"") for minutes or =IF(C2<60,C2/60,0)
Column B, =IF(C2>=60,C2/60,"") or =IF(C2>=60,C2,"") in minutes or =IF(C2>=60,C2/60,0) to place a Zero in the cell when the criteria is not met rather than using a blank