How does Excel use the text function to calculate the time difference between two dates?

How does Excel use the text function to calculate the time difference between two dates?

1. Create a new blank form first, rename "Calculate the time of two days";

2, open the form to enter the corresponding category title, such as "name, travel time, return time, travel long";

3, in the "name, travel time, return time" category to fill in the corresponding content;

4, in the "D3" cell input Formula "=text (C3-B3," [H]:mm:ss ")", will show the difference of time;

5, select the "D3" cell, when the cursor into the "Ten" character, drag down the copy;

6, Function Description: Use the return time minus travel time, get two different time of time, with the text function set out the time display format, where h represents the hour, m for minutes, s for seconds;