1	5	Use the LEN function in cell C8 to calculate the length of the "Text Stamp Phrase" in cell C7.
2	5	Use the SEARCH function in cell C9 to determine the position of the "#" symbol in the "Text Stamp Phrase" in cell C7.
3	6	Use the LEFT function in cell C10 to return the text "Employee number " (notice the space after number) from the "Text Stamp Phrase" in cell C7. Use a reference to the location of the "#" symbol in cell C9 as the "[num_chars]" argument. Since the "#" symbol is 1 character past the text you want to return, you will need to adjust the "[num_chars]" argument by subtracting 1 from the reference to cell C9.
4	6	Use the SEARCH function in cell C11 to determine the position of the characters " HH" (notice the space before the first H) in the "Text Stamp Phrase" in cell C7.
5	5	Use the MID function in cell C12 to return the text " entered the server room at " (notice the spaces at the beginning and end of the phrase) from the "Text Stamp Phrase" in cell C7. Use a reference to the location of the "#" symbol in cell C9 as the "start_num" argument. Since the "#" symbol is 1 character before the text you want to return, you will need to adjust the "[num_chars]" argument by adding 1 to the reference to cell C9. Use the difference between the location of the "#" symbol and the characters " HH" as the "num_chars" argument.
6	6	Use the RIGHT function in cell C13 to return the text " today." from the end of the "Text Stamp Phrase" in cell C7. The "[num_chars]" argument for your function is 7 since there are 7 characters in the text " today." (including the space at the beginning).
7	5	Use the HOUR function in cell D17 to calculate the "Hour" portion of the "Entry Swipe" found in cell C17. Copy and paste the function down to complete the "Hour" column of the table.
8	5	Use the MINUTE function in cell E17 to calculate the "Minute" portion of the "Entry Swipe" found in cell C17. Copy and paste the function down to complete the "Minute" column of the table.
9	5	Use the SECOND function in cell F17 to calculate the "Second" portion of the "Entry Swipe" found in cell C17. Copy and paste the function down to complete the "Second" column of the table.
10	6	Use the CONCAT function (or the CONCATENATE function if you are using Excel 2013 or earlier) in cell J17 to combine the text in cells G17, H17, and I17 to create a "Time Stamp". Notice that the syntax for the "Time Stamp" is "HH:MM:SS". You will need to insert the ":" symbol between "Hour" and "Minute" and between "Minute" and "Second". (Hint: you should have five arguments for your function. arguments 2 and 4 should be the ":" symbol.) Copy and paste your function to complete the "Time Stamp" column of the table.
11	6	Use the CONCAT function (or the CONCATENATE function if you are using Excel 2013 or earlier) to combine the text in cells C10, B17, C12, J17, and C13 (in that order) to create the "Text Stamp" in cell K17. The "Text Stamp" in cell K17 should read "Employee number 18 entered the server room at 00:53:02 today." Copy and paste your function to complete the "Text Stamp" column of the table.

M N O D P R 3 W X 37 : A D E G 1 J . 2 You xoresponsble for monitoring omploysos entry to your company's server room to complete this task you toulon a logo when employoos entered the room Tholog is a little bit dificultoread. It contains an employee number column) and a computer generated stamp test records when the employee snipped their Doard to enter the 4 room (column Cl. Use time and test functions to complete the tasks below Ultimately you want to create the "Tex Stamp"hcolumn Kther completes the phrase. 5 "Emplouce number tentered the server room : HMMSS today." for each row of the loc. You will pla "H" with the employee number and "HHMM:SS"vth the 1 Tort Stamp Ph Employee number tentered the soruer room at HHMMMSSTO B Phrase length 00 Location of 17 Hint Tacks 1-6 wil manuale me "Tex 10 Phrase Part 1 Employee number Stamp Phrasein sol C7 so that the 11 Location of 43 completed phiese can be entered in the table : 12 Phrase Part 2 entered the server room 13 Phrase Part 3 today 14 15 Decimal Equivalent 15 Employee Entry Swipe Hour Minute Second Hour Minute Secondime Stam Tort Stamp 17 00 03 02 03.02 15 43 007730 01 23 015122 13 007861 01 03 016203 20 30 0.11531 02 46 23 0246.21 21 012751 03 10 . 03-03:37 0.13333 ... 03 + 52 09.12.03 23 31 0 13009 03 3608 0336:08 26 0.15755 03 4701 85 14 0.1509 03 4 +9 00.40.43 26 015495 03 32 0357:32 ... 27 4 017773 04 55 04:16:56 20 32 0 1949 04 40 +7 04:40:47 ...... ..... 26 020724 04 F 25 04:58:26 31 022506 05 29 13 1905.25.13 2 0243 05 45 04 0645:04 . 19 ... 026752 06 11 06:26:14 1 027861 06 42 38 . 06:42:38 20. 029132 06 69 30 06:59:30 25 3 0.34000 00 0 53 00.10.53 36 08 20. 29 OR 20:29 37 03621 09 10 09 08:40:09 38 49 0.47293 11 21 01 It2t01 14 * 11 27 33 11:27:33 40 0.50246 1209 33 12.00.33 41 050331 12 04 12.04:46 49 051212 122759 12.27.69 0.3475 20 M N O D P R 3 W X 37 : A D E G 1 J . 2 You xoresponsble for monitoring omploysos entry to your company's server room to complete this task you toulon a logo when employoos entered the room Tholog is a little bit dificultoread. It contains an employee number column) and a computer generated stamp test records when the employee snipped their Doard to enter the 4 room (column Cl. Use time and test functions to complete the tasks below Ultimately you want to create the "Tex Stamp"hcolumn Kther completes the phrase. 5 "Emplouce number tentered the server room : HMMSS today." for each row of the loc. You will pla "H" with the employee number and "HHMM:SS"vth the 1 Tort Stamp Ph Employee number tentered the soruer room at HHMMMSSTO B Phrase length 00 Location of 17 Hint Tacks 1-6 wil manuale me "Tex 10 Phrase Part 1 Employee number Stamp Phrasein sol C7 so that the 11 Location of 43 completed phiese can be entered in the table : 12 Phrase Part 2 entered the server room 13 Phrase Part 3 today 14 15 Decimal Equivalent 15 Employee Entry Swipe Hour Minute Second Hour Minute Secondime Stam Tort Stamp 17 00 03 02 03.02 15 43 007730 01 23 015122 13 007861 01 03 016203 20 30 0.11531 02 46 23 0246.21 21 012751 03 10 . 03-03:37 0.13333 ... 03 + 52 09.12.03 23 31 0 13009 03 3608 0336:08 26 0.15755 03 4701 85 14 0.1509 03 4 +9 00.40.43 26 015495 03 32 0357:32 ... 27 4 017773 04 55 04:16:56 20 32 0 1949 04 40 +7 04:40:47 ...... ..... 26 020724 04 F 25 04:58:26 31 022506 05 29 13 1905.25.13 2 0243 05 45 04 0645:04 . 19 ... 026752 06 11 06:26:14 1 027861 06 42 38 . 06:42:38 20. 029132 06 69 30 06:59:30 25 3 0.34000 00 0 53 00.10.53 36 08 20. 29 OR 20:29 37 03621 09 10 09 08:40:09 38 49 0.47293 11 21 01 It2t01 14 * 11 27 33 11:27:33 40 0.50246 1209 33 12.00.33 41 050331 12 04 12.04:46 49 051212 122759 12.27.69 0.3475 20