SOLVED

Hello I need help with configuring out formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2517336%22%20slang%3D%22en-US%22%3EHello%20I%20need%20help%20with%20configuring%20out%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2517336%22%20slang%3D%22en-US%22%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIF(OR(B2%3D%22%22%2CG2%3D%22%22)%2C%22%22%2CIF(D2-C2%26lt%3B0.0208333333333333%2CG2-B2-0.0208333333333333-(F2-E2)%2CG2-D2%2BC2-B2-(F2-E2)))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20help%20configure%20out%20what%20is%26nbsp%3B%3CFONT%20size%3D%226%22%20color%3D%22%23993366%22%3E0.0208333333333333%26nbsp%3B%3CFONT%20color%3D%22%23000000%22%3Eis%20for%20in%20the%20the%20formula%3F%20Th%20formula%20is%20in%20H2%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%226%22%20color%3D%22%23993366%22%3E%3CFONT%20color%3D%22%23000000%22%3EThanks%20You%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%226%22%20color%3D%22%23993366%22%3E%3CFONT%20color%3D%22%23000000%22%3ESf49ers%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22TIME%20WORK%20SHEETS01.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F293564i679D396F5B537514%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22TIME%20WORK%20SHEETS01.jpg%22%20alt%3D%22TIME%20WORK%20SHEETS01.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2517336%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2517356%22%20slang%3D%22en-US%22%3ERe%3A%20Hello%20I%20need%20help%20with%20configuring%20out%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2517356%22%20slang%3D%22en-US%22%3EIt's%20the%20numerical%20value%20of%2030%20minutes.%20It%20appears%20they%20are%20deducting%20the%20lunch%20break%20and%20using%20the%20greater%20of%2030%20minutes%20or%20the%20actual%20time%20spent%20for%20lunch.%20But%2C%20that's%20just%20mathematically%20speaking%20-%20if%20the%20calculation%20is%20being%20used%20for%20payroll%20purposes%2C%20I%20couldn't%20tell%20you%20if%20such%20a%20calculation%20is%20correct%20according%20to%20any%2Fall%20applicable%20laws%2Fregulations.%3C%2FLINGO-BODY%3E
Contributor
=IF(OR(B2="",G2=""),"",IF(D2-C2<0.0208333333333333,G2-B2-0.0208333333333333-(F2-E2),G2-D2+C2-B2-(F2-E2)))

 

I need help configure out what is 0.0208333333333333 is for in the the formula? Th formula is in H2

 

Thanks You

 

Sf49ersTIME WORK SHEETS01.jpg

 

1 Reply
best response confirmed by sf49ers (Contributor)
Solution
It's the numerical value of 30 minutes. It appears they are deducting the lunch break and using the greater of 30 minutes or the actual time spent for lunch. But, that's just mathematically speaking - if the calculation is being used for payroll purposes, I couldn't tell you if such a calculation is correct according to any/all applicable laws/regulations.