Deducting break from total hours worked

**robremsk01** · 09-20-2013, 11:12 AM

Originally Posted by Tony Valko

Like this:

=MOD(E90-D90,1)

Do you want to round then subtract the break or subtract the break then round?

This equation does not deduct a 30 minute break. It does not matter, either way the number of hours worked comes out to be the same whether you deduct the break before or after.

**Tony Valko** · 09-20-2013, 01:37 PM

That formula was to show you how to calculate the hours worked.

To deduct 30mins if the total is >6hrs...

D90 = time in
E90 = time out

=MOD(E90-D90,1)-IF(MOD(E90-D90,1)>6/24,30/1440)

Format as h:mm