How to calculate between two times?
To get the time difference, just use End Time - Start time. In this case, it would be =B2-A2.
The answer should be 9:14:30, 9 hours 14 minutes and 30 seconds.
Or you can use HOUR, MINUTE and SECOND formula.
The result would depend on which formula that you choose.