help with time formula

I'm trying to locate a formula to help with a report. What I need is if a employee clocks out before a time. I need a HE/LOA if not leave the cell blank. This is what I have tried and not sure if its the right formula for this task. Can anyone help with this formula.

IF(J105<TIME(15,30,0),"",IF(J105>TIME(22,54,0),"","HE/LOA"))

From your description, I think this is what you want:

Excel 2016 (Windows) 32 bit

	A​	B​	C​	D​	E​	F​	G​	H​	I​
1​	Operator ID	Name	EmplID	Late	Absent	explanation of exception		In for day	Out for day
2​	AAHLUWA	Arvinder Ahluwalia	10031531​					14:51​	16:42​
3​	ABOONE	Anna Boone	73058938​			HE/LOA		14:36​	15:20​

Excel 2016 (Windows) 32 bit

	F​
3​	=IF(I3<TIME(15,30,0),"HE/LOA","")

Thanks you for the reply. below is what I'm getting. every cell is blank. My shift runs from 15:00 to 23:00. Anyone that leaves prior to 23:00 has been granted an HE/LOA. I'm having the biggest brain freeze on this. Hopefully this explains what I'm trying to do. So in the cell I need anyone who leaves prior to 23:00 to say HE/LOA and anyone who stays for the full day to be blank.

=IF(J3<TIME(15,30,0),"HE/LOA","")

Thanks to both of your for your responses. They both do work. I found a glitch in my spreadsheet that will always fill in with a black. I use the VLOOKUP for out for day time. This puts a value in the cell that is not recognized as a time for some reason. This was always putting a blank where the result should have been.

Thanks

damdtaylor

Glad to have helped.