sumsaam
Board Regular
- Joined
- Dec 31, 2012
- Messages
- 82
- Office Version
- 2010
- Platform
- Windows
this is time attendance sheet i want to filter time stamps with id, name and date filter in a certain cell. and every employee may have 4 or six time stamps too. and i want every time in separate cell. what will be formula for that. thank you
| 12-03-2023.xlsx | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | Emp ID | First Name | Date | Time | ||
| 2 | 1 | Sumsaam | 01-03-2023 | 20:45 | ||
| 3 | 1 | Sumsaam | 01-03-2023 | 22:06 | ||
| 4 | 1 | Sumsaam | 02-03-2023 | 16:41 | ||
| 5 | 1 | Sumsaam | 02-03-2023 | 21:50 | ||
| 6 | 1 | Sumsaam | 02-03-2023 | 22:07 | ||
| 7 | 1 | Sumsaam | 04-03-2023 | 13:38 | ||
| 8 | 1 | Sumsaam | 04-03-2023 | 22:06 | ||
| 9 | 3 | Mustafa | 01-03-2023 | 11:09 | ||
| 10 | 3 | Mustafa | 01-03-2023 | 22:06 | ||
| 11 | 3 | Mustafa | 02-03-2023 | 11:08 | ||
| 12 | 3 | Mustafa | 02-03-2023 | 22:07 | ||
| 13 | 3 | Mustafa | 03-03-2023 | 15:37 | ||
| 14 | 3 | Mustafa | 03-03-2023 | 22:02 | ||
| 15 | 3 | Mustafa | 04-03-2023 | 11:07 | ||
| 16 | 3 | Mustafa | 04-03-2023 | 22:06 | ||
| 17 | 4 | Afaq | 02-03-2023 | 11:09 | ||
| 18 | 4 | Afaq | 02-03-2023 | 22:07 | ||
| 19 | 4 | Afaq | 03-03-2023 | 15:03 | ||
| 20 | 4 | Afaq | 03-03-2023 | 22:02 | ||
| 21 | 4 | Afaq | 04-03-2023 | 11:07 | ||
| 22 | 4 | Afaq | 04-03-2023 | 22:07 | ||
Sheet | ||||||
Last edited by a moderator:
