In or Out

[Flopem123]

Hi Everyone,

I have a spreadsheet with around 10 individual sheets and each of these sheets records the times of an individual. On these sheets there are 5 IN times and 5 OUT times. This allows people to clock in and out multiple times during the day if they wish.

To make things more manageable I would like a sheet which will tell me who's in and who's out. I have looked at the IF Blank function but I think I might be going down the wrong path as it needs to look at multple cells but only if the IN has been completed.

Day	In	Out	In2	Out2	In3	Out3	In4	Out4	In5	Out5
Monday	07:45	11:35	12:20	16:00
Tuesday	07:40	11:35	12:20	16:00
Wednesday	07:40	11:40	12:25	16:05
Thursday	07:40	11:40	12:25	16:05
Friday	07:45	09:10	09:25	13:00	13:50	16:00

HJ IN
HK OUT
PL IN
FJ IN
TY IN

Any help would be much appreciated

Thanks

 

[Crystalyzer]

Assuming your data starts at A2 you could use this formula

=IF(MOD(COUNTBLANK(B2:K2),2)=0,"OUT","IN")

 

[Peter_SSs]

Or if the in/out times are actual times (numerical) you could also use this variation
=IF(MOD(COUNT(B2:K2),2),"IN","OUT")

 

[Flopem123]

That's great, worked perfectly

 

[Peter_SSs]

Glad you got a successful outcome. Thanks for the follow-up.