Peter Muller
Board Regular
- Joined
- Oct 15, 2018
- Messages
- 133
- Office Version
- 365
- Platform
- Windows
Good evening,
I have a table with information (Emp name, date, start and end times), and i require a formulae to search the emp name, date, start and end times.
Please help
Thank you
I have a table with information (Emp name, date, start and end times), and i require a formulae to search the emp name, date, start and end times.
Please help
Thank you
Personnel No. | First Name | Date | Time | Punch Status |
000008633 | Employee 1 | 2020-01-28 | 18:30:17 | Check-Out |
000008634 | Employee 2 | 2020-01-28 | 18:24:47 | Check-Out |
000008635 | Employee 3 | 2020-01-28 | 18:23:23 | Check-Out |
000008636 | Employee 4 | 2020-01-28 | 18:20:06 | Check-Out |
000008633 | Employee 1 | 2020-01-28 | 12:50:37 | Check-In |
000008635 | Employee 3 | 2020-01-28 | 12:50:28 | Check-In |
000008634 | Employee 2 | 2020-01-28 | 08:29:16 | Check-In |
000008636 | Employee 4 | 2020-01-28 | 08:09:47 | Check-In |
000008634 | Employee 2 | 2020-01-27 | 19:30:17 | Check-Out |
000008636 | Employee 4 | 2020-01-27 | 19:20:06 | Check-Out |
000008633 | Employee 1 | 2020-01-27 | 18:18:49 | Check-Out |
000008635 | Employee 3 | 2020-01-27 | 17:51:01 | Check-Out |
000008635 | Employee 3 | 2020-01-27 | 07:50:37 | Check-In |
000008634 | Employee 2 | 2020-01-27 | 07:02:12 | Check-In |
000008636 | Employee 4 | 2020-01-27 | 05:42:34 | Check-In |
000008633 | Employee 1 | 2020-01-27 | 05:05:42 | Check-In |
Results Sheet | ||||
2020-01-27 | 2020-01-27 | 2020-01-28 | 2020-01-28 | |
Employee Name | Check-In | Check-Out | Check-In | Check-Out |
Employee 1 | Formulae? | Formulae? | Formulae? | Formulae? |
Employee 2 | 07:02:12 | 19:30:17 | 08:29:16 | 18:24:47 |
Employee 3 | ||||
Employee 4 |