Once Excel recognizes the values as times, you can use formulas to calculate the difference.
Step 3: Calculate Total Working Hours
Suppose the start time is in cell E2 and the end time is in cell F2.
Use this formula:
=F2-E2This calculates the difference between the end time and start time.
For example:
