Employee ID Full Name FIRST LAST EMAIL ID
E001 Alice Thomas Alice Thomas alicethomas@company.com
E002 Irene Singh Irene Singh irene singh@company.com
E003 Emily Thomas Emily Thomas emilythomas@company.com
E004 Bob Kumar Bob umar bobumar@company.com
E005 Bob Kumar Bob umar bobumar@company.com
E006 Emily Kumar Emily Kumar emily kumar@company.com
E007 Henry Fernandez Henry nandez henrynandez@company.com
E008 Irene Singh Irene Singh irene singh@company.com
E009 Carol Brown Carol Brown carol brown@company.com
E010 Carol Lee Carol ol Lee carolol lee@company.com
E011 Emily Brown Emily Brown emily brown@company.com
E012 Alice Singh Alice Singh alice singh@company.com
E013 Bob Thomas Bob omas bobomas@company.com
E014 Alice Wilson Alice Wilson alicewilson@company.com
E015 Carol Sharma Carol Sharma carolsharma@company.com
E016 Carol Sharma Carol Sharma carolsharma@company.com
E017 Bob Wilson Bob lson boblson@company.com
E018 Henry Singh Henry Singh henry singh@company.com
E019 Emily Kumar Emily Kumar emily kumar@company.com
E020 Bob Wilson Bob lson boblson@company.com
E021 Frank Wilson Frank Wilson frankwilson@company.com
E022 Bob Patel Bob atel bobatel@company.com
E023 Bob Kumar Bob umar bobumar@company.com
E024 Henry Wilson Henry Wilson henrywilson@company.com
E025 Emily Singh Emily Singh emily singh@company.com
E026 Frank Patel Frank Patel frank patel@company.com
E027 Grace Sharma Grace Sharma gracesharma@company.com
E028 Alice Lee Alice ce Lee alicece lee@company.com
E029 Frank Patel Frank Patel frank patel@company.com
E030 David Singh David Singh david singh@company.com
E031 Alice Kumar Alice Kumar alice kumar@company.com
E032 Carol Singh Carol Singh carol singh@company.com
E033 Alice Fernandez Alice nandez alicenandez@company.com
E034 Frank Fernandez Frank nandez franknandez@company.com
E035 Carol Wilson Carol Wilson carolwilson@company.com
E036 Emily Brown Emily Brown emily brown@company.com
E037 Bob Singh Bob ingh bobingh@company.com
E038 Carol Kumar Carol Kumar carol kumar@company.com
E039 Grace Kumar Grace Kumar grace kumar@company.com
E040 Emily Fernandez Emily nandez emilynandez@company.com
E041 Bob Sharma Bob arma bobarma@company.com
E042 Jack Brown Jack Brown jackbrown@company.com
E043 Carol Lee Carol ol Lee carolol lee@company.com
E044 Henry Sharma Henry Sharma henrysharma@company.com
E045 Alice Thomas Alice Thomas alicethomas@company.com
E046 Jack Fernandez Jack andez jackandez@company.com
E047 Irene Kumar Irene Kumar irene kumar@company.com
E048 Emily Brown Emily Brown emily brown@company.com
E049 Irene Johnson Irene ohnson ireneohnson@company.com
E050 Henry Wilson Henry Wilson henrywilson@company.com
Count Character Joining Date Date of Birth Login Time Logout Time Department Upper case
12 02/06/22 05/11/94 08:12 AM 04:41 PM Legal LEGAL
11 07/22/23 10/09/99 09:18 AM 06:58 PM Operations OPERATIONS
12 05/17/18 07/12/92 08:10 AM 06:09 PM Marketing MARKETING
9 11/01/22 12/06/99 09:13 AM 06:01 PM Finance FINANCE
9 07/02/18 12/03/93 08:16 AM 05:30 PM Operations OPERATIONS
11 06/23/20 08/23/98 09:33 AM 06:25 PM Legal LEGAL
15 12/03/21 09/22/86 09:08 AM 06:32 PM Marketing MARKETING
11 12/18/19 09/15/89 09:38 AM 06:00 PM Finance FINANCE
11 03/06/22 10/22/99 09:05 AM 05:32 PM Logistics LOGISTICS
9 12/23/19 05/03/85 09:05 AM 05:14 PM IT IT
11 11/13/19 03/30/93 09:11 AM 05:21 PM Admin ADMIN
11 07/16/18 04/29/90 09:50 AM 06:31 PM Legal LEGAL
10 08/11/21 01/08/91 08:12 AM 06:08 PM Finance FINANCE
12 09/29/18 03/22/98 09:52 AM 07:47 PM Support SUPPORT
12 01/22/20 06/08/87 09:30 AM 06:30 PM Sales SALES
12 03/02/21 02/08/99 08:28 AM 05:05 PM Logistics LOGISTICS
10 06/30/19 04/08/99 08:38 AM 05:06 PM Legal LEGAL
11 08/04/20 12/12/89 09:11 AM 06:02 PM IT IT
11 11/08/19 11/26/86 08:07 AM 04:42 PM Legal LEGAL
10 08/25/22 11/16/98 09:39 AM 05:49 PM Admin ADMIN
12 10/23/21 02/15/86 08:27 AM 05:19 PM Finance FINANCE
9 07/21/22 03/03/98 08:35 AM 06:23 PM Admin ADMIN
9 02/23/19 12/11/99 08:17 AM 06:00 PM Sales SALES
12 06/27/19 10/13/89 09:25 AM 05:51 PM Logistics LOGISTICS
11 03/09/19 03/08/89 09:00 AM 05:26 PM IT IT
11 05/27/24 07/17/97 08:26 AM 06:24 PM Logistics LOGISTICS
12 06/06/18 06/27/98 09:58 AM 06:08 PM Operations OPERATIONS
9 04/08/20 12/26/86 09:31 AM 06:13 PM HR HR
11 05/22/21 10/26/97 09:07 AM 06:18 PM Logistics LOGISTICS
11 01/23/22 08/05/85 08:00 AM 04:05 PM Marketing MARKETING
11 03/02/20 07/18/89 08:04 AM 04:20 PM HR HR
11 01/22/20 10/07/97 09:45 AM 07:19 PM Logistics LOGISTICS
15 03/24/18 01/13/86 09:47 AM 07:45 PM Support SUPPORT
15 01/12/18 10/26/85 08:56 AM 05:18 PM Marketing MARKETING
12 05/19/23 05/17/99 08:32 AM 04:32 PM Marketing MARKETING
11 02/19/24 06/15/98 09:10 AM 05:13 PM Support SUPPORT
9 05/10/23 03/06/00 08:56 AM 06:50 PM Admin ADMIN
11 02/11/22 11/05/97 09:40 AM 06:17 PM HR HR
11 03/02/20 11/29/90 09:55 AM 06:18 PM IT IT
15 06/30/23 07/05/86 09:46 AM 06:56 PM Operations OPERATIONS
10 06/25/23 02/12/90 08:33 AM 05:58 PM Operations OPERATIONS
10 06/27/24 05/15/94 08:16 AM 04:46 PM Operations OPERATIONS
9 12/12/19 10/01/98 08:20 AM 05:04 PM Logistics LOGISTICS
12 12/08/23 02/03/98 08:07 AM 05:06 PM HR HR
12 11/04/19 03/02/93 09:21 AM 06:29 PM IT IT
14 05/03/20 04/01/98 08:03 AM 04:35 PM Finance FINANCE
11 10/31/22 03/16/85 08:07 AM 04:42 PM Support SUPPORT
11 10/14/21 07/06/97 08:02 AM 05:55 PM Legal LEGAL
13 02/23/23 12/10/00 09:39 AM 07:04 PM HR HR
12 06/04/18 12/14/95 09:02 AM 05:39 PM Marketing MARKETING
Name (department) Age Experience Day of week of joinning Total working hours
Alice Thomas(Legal) 31 4 Sunday 08:29
Irene Singh(Operations) 26 2 Saturday 09:40
Emily Thomas(Marketing) 33 7 Thursday 09:59
Bob Kumar(Finance) 26 3 Tuesday 08:48
Bob Kumar(Operations) 32 7 Monday 09:14
Emily Kumar(Legal) 27 5 Tuesday 08:52
Henry Fernandez(Marketing39 4 Friday 09:24
Irene Singh(Finance) 36 6 Wednesday 08:22
Carol Brown(Logistics) 26 3 Sunday 08:27
Carol Lee(IT) 40 6 Monday 08:09
Emily Brown(Admin) 32 6 Wednesday 08:10
Alice Singh(Legal) 35 7 Monday 08:41
Bob Thomas(Finance) 34 4 Wednesday 09:56
Alice Wilson(Support) 27 7 Saturday 09:55
Carol Sharma(Sales) 38 6 Wednesday 09:00
Carol Sharma(Logistics) 26 5 Tuesday 08:37
Bob Wilson(Legal) 26 6 Sunday 08:28
Henry Singh(IT) 36 5 Tuesday 08:51
Emily Kumar(Legal) 39 6 Friday 08:35
Bob Wilson(Admin) 27 3 Thursday 08:10
Frank Wilson(Finance) 39 4 Saturday 08:52
Bob Patel(Admin) 27 3 Thursday 09:48
Bob Kumar(Sales) 26 7 Saturday 09:43
Henry Wilson(Logistics) 36 6 Thursday 08:26
Emily Singh(IT) 36 6 Saturday 08:26
Frank Patel(Logistics) 28 1 Monday 09:58
Grace Sharma(Operations) 27 7 Wednesday 08:10
Alice Lee(HR) 39 5 Wednesday 08:42
Frank Patel(Logistics) 28 4 Saturday 09:11
David Singh(Marketing) 40 4 Sunday 08:05
Alice Kumar(HR) 36 6 Monday 08:16
Carol Singh(Logistics) 28 6 Wednesday 09:34
Alice Fernandez(Support) 39 7 Saturday 09:58
Frank Fernandez(Marketing)40 8 Friday 08:22
Carol Wilson(Marketing) 26 2 Friday 08:00
Emily Brown(Support) 27 2 Monday 08:03
Bob Singh(Admin) 25 2 Wednesday 09:54
Carol Kumar(HR) 28 4 Friday 08:37
Grace Kumar(IT) 35 6 Monday 08:23
Emily Fernandez(Operations39 2 Friday 09:10
Bob Sharma(Operations) 35 2 Sunday 09:25
Jack Brown(Operations) 31 1 Thursday 08:30
Carol Lee(Logistics) 27 6 Thursday 08:44
Henry Sharma(HR) 27 2 Friday 08:59
Alice Thomas(IT) 32 6 Monday 09:08
Jack Fernandez(Finance) 27 5 Sunday 08:32
Irene Kumar(Support) 40 3 Monday 08:35
Emily Brown(Legal) 28 4 Thursday 09:53
Irene Johnson(HR) 25 3 Thursday 09:25
Henry Wilson(Marketing) 30 7 Monday 08:37
Worked more than 8hrsTasks
YES
YES TEXT Functions
YES
YES 1. Extract First and Last Name left
YES
YES
YES 2. Create Employee Email ID lower
YES Format: firstnamelastname@company.com
YES Use LOWER, &
YES
YES 3. Count Number of Characters in Full Name len
YES Use LEN function.
YES
YES 4. Convert Department Names to Upper Case upper
YES Use UPPER function.
YES
YES 5. Show “Name (Department)” Format
YES Example: Alice Johnson (Sales)
YES Use TEXTJOIN
YES
YES DATE & TIME Functions
YES
YES 1. Calculate Age of Employee
YES Use TEXT and TODAY.
YES
YES 2. Find Total Experience (in Years and Months)
YES Use YEARFRAC and TODAY.
YES
YES 3. Day of the Week of Joining Date
YES Use TEXT(Joining Date, "dddd") or WEEKDAY.
YES
YES 4. Calculate Total Working Hours
YES Use =Logout Time - Login Time
YES Format result as h:mm or use TEXT(..., "h:mm").
NO
YES 5. Find Who Has Worked More Than 8 Hours
YES Use IF to compare working hours with 8:00.
YES
YES
YES Use TEXT(Login Time, "HH:MM").
YES
YES
YES
YES
YES
YES
YES
YES
YES
YES
