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.
HJ IN
HK OUT
PL IN
FJ IN
TY IN
Any help would be much appreciated
Thanks
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