A brief introduction to the tetext function



TEXT



Converts a numeric value to text in the specified numeric format.



	grammar



TEXT(value,format_text)Value is a numeric value, a formula that evaluates to a numeric value, or a reference to a cell that contains a numeric value. Format_text is the number format in text form in the Category box on the Number tab in the Format Cells dialog box.



	illustrate



Format_text cannot contain an asterisk (*). Calling the "Cells" command through the "Format" menu, and then formatting the cells on the "Number" tab will only change the format of the cells without affecting the values ​​in them. Use the TEXT function to convert a numeric value into formatted text, without the result being used as a number in calculations.



How to use



1. First create a new blank table and rename it "Calculate the length of time between two dates".



	



Excel2010



2. Open the form and enter the corresponding category title, such as "name, business trip time, return time, business trip duration".



	



Excel2010



3. Fill in the corresponding content in the "name, business trip time, return time" category.   



	



Excel2010



4. Enter the formula "=TEXT(C3-B3,"[h]:mm:ss")" in cell "D3", and the time difference will be displayed.



	



Excel2010



5. Select cell "D3". When the cursor changes to a "cross" shape, drag down to copy.



	



Excel2010



6. Function description: Subtract the business trip time from the return time to get the length of two different times. Use the TEXT function to set the time display format; where h represents hours, m represents minutes, and s represents seconds.



	



Excel2010



The above is what the editor has shared with you about the role and usage of the text function in Excel2010 functions. I hope everyone can apply what they have learned! For more exciting tutorials, remember to follow Huajun Software Park!