Home

Excel Formula Help - Timesheets

%3CLINGO-SUB%20id%3D%22lingo-sub-709383%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Help%20-%20Timesheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-709383%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20timesheet%20and%20I%20want%20to%20have%20a%20note%20appear%20if%20the%20employee%20has%20not%20entered%20the%20correct%20times%20for%20their%20breaks.%3C%2FP%3E%3CP%3ESo%20I%20think%20an%20IF%20formula%20would%20be%20best%20but%20it's%20not%20saying%20the%20correct%20response.%20I%20have%20a%20formula%20to%20work%20out%20how%20long%20the%20break%20has%20been%20from%20the%20times%20entered.%20I%20want%20to%20say%20IF%20the%20answer%20in%20that%20formula%20is%20not%20equal%20to%200.33%20then%20return%20a%20Check%20your%20break.%20But%20everytime%20I%20do%20this%20it%20fails%20in%20the%20execution.%20I've%20attached%20my%20sheet%20to%20show.%20I've%20tried%20an%20AND%20function%20as%20well.%3C%2FP%3E%3CP%3EHelp!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-709383%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-710078%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Help%20-%20Timesheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-710078%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F363422%22%20target%3D%22_blank%22%3E%40squirrell%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20use%3C%2FP%3E%0A%3CPRE%3E%3DIF(MROUND(F9-E9%2C%220%3A10%22)%3DTIME(0%2C20%2C0)%2C%22Complete%22%2C%22Check%20Recess%20Break%22)%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
squirrell
Occasional Visitor

I have created a timesheet and I want to have a note appear if the employee has not entered the correct times for their breaks.

So I think an IF formula would be best but it's not saying the correct response. I have a formula to work out how long the break has been from the times entered. I want to say IF the answer in that formula is not equal to 0.33 then return a Check your break. But everytime I do this it fails in the execution. I've attached my sheet to show. I've tried an AND function as well.

Help!

1 Reply

@squirrell 

 

You may use

=IF(MROUND(F9-E9,"0:10")=TIME(0,20,0),"Complete","Check Recess Break")

 

Related Conversations