Question: how to calculate time difference in seconds in excel?
Answer: To get the total seconds between two times, you multiply the time difference by 86400, which is the number of seconds in one day (24 hours * 60 minutes * 60 seconds = 86400). Note. For the results to display correctly, the General format should be applied to the cells with your time difference formula.