Hi,

I am creating a spreadsheet to record staff working hours. Once a staff member works more than 40 hours, they become eligible for overtime at an enhanced rate. I would like the spreadsheet to show how many hours overtime (if applicable) they have worked.

The total hours payable for the week (less any dinner breaks) is calculated in the cell B1 which is formatted "[h]:mm".

I would like the overtime cell to show 0 if they have worked less than 40 hours and then just the amount of overtime if they have worked more than 40 hours. I have tried using the formula:

Formula: copy to clipboard 
=IF(B2>40,(B2-40),0)


With the cell being formatted "[h]:mm" however this always remains as 0:00 no matter how many hours have been worked.

Can you please tell me where I am going wrong,

Thanks