SoftMaker.com

@Woody44: formula is correct, overtime is based on one of the cells in the fomula, not on fixed 40 hours. It doesn't matter if the overtime is applied by the day or by the week. I think the change I provided would work -- if by the day, just substitute 8 ( or 7, or 6) in place of the 40. I don't un...

Received reply in email conversation.

from Support:
Just use ROUND() on the IfElse parameter, for example "=IF(K26=0,"",ROUND(K26-($G$8*$G$9),5))". That should do the trick.

@Woody44: formula is correct, overtime is based on one of the cells in the fomula, not on fixed 40 hours.

Hello! I am just adapting simple work hours collection sheet. The row has 3 pairs of start/stop times, one cell for break, one cell for correction, all defined as Date/Time. I make a calculation into workhours [K19] =(D19-C19)+(F19-E19)+(H19-G19)-I19+J19 Then calculate potential overtime as [L19] =I...