Forum Discussion
Formulas and Functions
I need assistance with a formula. I am attempting to create a formula that will deduct if a number is bigger. For example, if a person works over eight hours, subtract thirty minutes for lunch, and...
jthodges Some examples in the attached file, using the following formula (column C contains the duration):
=IF(C2>10/24,C2-1/24,IF(C2>8/24,C2-1/48,0))