6 Minute Allowance For Pay Period

[Billy Spivy]

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

[davsth]

the question is what does 38:52 become if it is 38:58
then
=MIN($C$3,IF(SUM(D4:D10)>0,SUM(D4:D10)+6/60/24,0))

if it remains 38:52
=MIN($C$3,IF(SUM(D4:D10)>=942/60/24,SUM(D4:D10)+6/60/24,SUM(D4:D10)))

appologies tweaked formula, but bet you could have fixed it

[Billy Spivy]

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

[davsth]

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

[Billy Spivy]

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?

[Billy Spivy]

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

[Billy Spivy]

Can you please check K10? Something strange happened.

[Billy Spivy]

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

[davsth]

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

[Billy Spivy]

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