Time sheet return IN and OUT based on criteria

[gj7592]

Hi,

I have a time sheet for which I would like to return "IN" and "OUT" based on data inputted.

In reference to the sample sheet;
1. If there is an in time in column H, then the result should show "IN"
2. If there is an in time in column H and an out time in column I, the the result should show "OUT"
3. If there is no in time in column H and no out time in column I, then the result should be a blank cell.

Any help would be appreciated.

Thanks

[AliGW]

Try this:

=IF(AND(H2<>"",I2<>""),"OUT",IF(AND(H2<>"",I2=""),"IN",""))

[gj7592]

Thank you so much @AliGW, exactly what I needed .

[AliGW]

You're welcome.