Excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1681390%22%20slang%3D%22en-US%22%3EExcel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1681390%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20populate%20under%20a%20column%20whether%20if%20the%20person%20did%20their%20work%20on%20time%20%22Y%22%2C%20didn't%20do%20it%20%22N%22%20or%20they%20turned%20it%20in%20late%20%22L%22.%20The%20column%20I%20am%20trying%20for%20%22y%22%2C%20%22n%22%20or%20%22L%22%20to%20populate%20and%20reference%20from%20contains%20a%20time%20frame%20such%20as%2011%3A59%3A45%20AM%2C%20I%20have%20seen%20it%20done%20on%20dates%20not%20sure%20if%20it's%20possible%20with%20a%20time%20value%3F%20I%20tried%20IF%2C%20AND%2C%20TIME%20VALUE%20formulas%20but%20no%20luck.%20The%20question%20I%20have%20is%20how%20can%20I%20populate%20%22Y%22%2C%20%22N%22%20or%20%22L%22%20under%20a%20column%20that%20is%20referencing%20the%20time%20frames%20column%2C%20I%20am%20using%20vlookup%20to%20reference%20unique%20emails%20since%20%2C%20the%20work%20is%20considered%20late%20if%20it%20passes%2012%3A00%3A00%20PM.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1681390%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1681958%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1681958%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F798094%22%20target%3D%22_blank%22%3E%40cgabriel0%3C%2FA%3E%26nbsp%3BPerhaps%20the%20attached%20example%20points%20you%20into%20the%20right%20direction.%20I've%20used%20the%20IFS%20function.%20If%20it%20is%20not%20supported%20by%20your%20Excel%20version%2C%20the%20alternative%20is%20to%20use%20a%20nested%20IF%20function%2C%20which%20is%20also%20provided%20in%20the%20example.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1682053%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1682053%22%20slang%3D%22en-US%22%3EWhat%20you%20are%20trying%20is%20not%20clear%20%26amp%3B%20loud%20please%20share%20some%20sample%20data%20with%20us%20for%20better%20understanding%20to%20fix%20it.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello,

I am trying to populate under a column whether if the person did their work on time "Y", didn't do it "N" or they turned it in late "L". The column I am trying for "y", "n" or "L" to populate and reference from contains a time frame such as 11:59:45 AM, I have seen it done on dates not sure if it's possible with a time value? I tried IF, AND, TIME VALUE formulas but no luck. The question I have is how can I populate "Y", "N" or "L" under a column that is referencing the time frames column, I am using vlookup to reference unique emails since , the work is considered late if it passes 12:00:00 PM. 

2 Replies
Highlighted

@cgabriel0 Perhaps the attached example points you into the right direction. I've used the IFS function. If it is not supported by your Excel version, the alternative is to use a nested IF function, which is also provided in the example.

Highlighted
What you are trying is not clear & loud please share some sample data with us for better understanding to fix it.