Using TEXT formula to calculate time.
Use =TEXT(End time-Start time,"format to use") to calculate between two times. Simply replace the format to use with:
h = hour
mm = minutes
ss = seconds.
Example:
You can also personalize the formula.
This will return the result based on each preference.
