muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all..
how to solve this problem:
this criteria:
Clock in:
06.00.00 till 07.15.00
Clockout
17.00.00 till 24.00.00
with option
"ok" or "late" or "overtime"
any one help me out, greately appreciated..
my target in column B2 down
susant0
how to solve this problem:
this criteria:
Clock in:
06.00.00 till 07.15.00
Clockout
17.00.00 till 24.00.00
with option
"ok" or "late" or "overtime"
nov 2023 (version 1).xlsb | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | date-time | expected result | name | ||
2 | 01/11/2023 07:04:15 | ok | Kiki | ||
3 | 01/11/2023 17:19:41 | ok | Kiki | ||
4 | 02/11/2023 05:58:26 | late | Sisca | ||
5 | 02/11/2023 17:34:42 | ok | Sisca | ||
6 | 01/11/2023 07:07:25 | ok | Darwin | ||
7 | 01/11/2023 16:43:44 | overtime | Darwin | ||
8 | 02/11/2023 07:05:45 | Jack | |||
9 | 02/11/2023 17:23:44 | Jack | |||
10 | 04/11/2023 07:06:27 | Milla | |||
11 | 04/11/2023 17:36:17 | Milla | |||
Sheet1 (2) |
any one help me out, greately appreciated..
my target in column B2 down
susant0