In or Out

Flopem123

New Member
Joined
Aug 31, 2020
Messages
7
Office Version
  1. 365
Platform
  1. Windows
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.

DayInOutIn2Out2In3Out3In4Out4In5Out5
Monday07:4511:3512:2016:00
Tuesday07:4011:3512:2016:00
Wednesday07:4011:4012:2516:05
Thursday07:4011:4012:2516:05
Friday07:4509:1009:2513:0013:5016:00



HJ IN
HK OUT
PL IN
FJ IN
TY IN

Any help would be much appreciated

Thanks
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,475
Office Version
  1. 365
Platform
  1. Windows
Or if the in/out times are actual times (numerical) you could also use this variation
=IF(MOD(COUNT(B2:K2),2),"IN","OUT")
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,475
Office Version
  1. 365
Platform
  1. Windows
Glad you got a successful outcome. Thanks for the follow-up. :)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,141
Messages
5,570,406
Members
412,322
Latest member
mohi021
Top