6 Minute Allowance For Pay Period

Hello,

How can the formula in 'YTD Log' E10 be edited so it allows for 6 minutes lost per pay period? For instance if an employees total time for the pay period is 39:54 it would adjust to 40 hours.

Thank you so much,
Billy

Thank you for the reply. Does this work for 39 hours and 54 minutes?

I've updated the formula above, if you are using the second formula

Thank you I want to be sure that if their hours are 39:53 it will remain that. But if their hours are 39:54 up to 40 it adjusts to make it 40 hours. Will that formula do that?

It does work thanks so much. I put in some clock times to test.

I did some copy paste and messed up the format there it should be currency not hours.

Can you please check K10? Something strange happened.

appoligies
=MIN($C$3,IF(SUM(D4:D10)>=2394/60/24,SUM(D4:D10)+6/60/24,SUM(D4:D10)))

39*60+54=2394


I need more coffee

I think it was better before. I did a test if the employee has 39:53 hours it should adjust to 39:59.