1, calculating the time interval hours
To calculate the interval between two times, you can use the formula:
= (End Time-Start Time) *24
2. Calculate the time interval in minutes
To calculate the minute interval between two times, you can use the following formula:
= (end time-start time) * 1440
Step 3 calculate the time interval
To calculate the number of seconds between times, you can use the following formula:
= (end time-start time) *24*60*60