Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2 . 1 0 Use the CONCAT function in cell J 1 2 ) to combine the text in cells G 1 2 ) ,
Use the CONCAT function in cell J to combine the text in cells and to create a "Time Stamp".
a Notice that the syntax for the "Time Stamp" is HH:MM:SS
b You will need to insert the : symbol between "Hour" and "Minute" and between "Minute" and "Second".
c Hint: you should have five arguments for your function. arguments and should be the : symbol.
d Copy and paste your function to complete the "Time Stamp" column of the table.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started