I have the below formula correctly which deducts 30mins lunch break from work times
=IF(COUNT(C23:D26)=0,"",SUM(D23-C23+D24-C24+D25-C25+D26-C26))-"0:30"+0
How do I amend this to only deduct the 30 mins if they work longer than 5 hours. My guys sometimes only work 4 hours but then work longer days other days.
Thanks in advance!
=IF(COUNT(C23:D26)=0,"",SUM(D23-C23+D24-C24+D25-C25+D26-C26))-"0:30"+0
How do I amend this to only deduct the 30 mins if they work longer than 5 hours. My guys sometimes only work 4 hours but then work longer days other days.
Thanks in advance!