I often see netizens on Quora asking how to calculate time in Excel. So I sorted out several related calculation methods and shared them with you guys.
Merge Date And Time
As shown in the figure below, how to merge the date in column A and the time in column B into data with both date and time?
Just type =A1+B2 in cell C2 and press enter key.
Split Date And Time
If you want to split the data that is combined with date and time, what should you do?
Just type =INT(A2) in cell D2 and press Enter key.
Type =C2-D2 in cell E2 and press Enter key.
Remember to change the format of E2 into time.
Calculate The Interval In Hours
How to calculate how many hours are between two times?
Subtract the start time from the end time, and then multiply it by 24.
Calculate The Interval In Minutes
How to calculate how many minutes are between two times?
Subtract the start time from the end time, and then multiply it by 1440.
This tutorial only explains a few simple but very commonly used methods for calculating dates. We will introduce other methods to you in later tutorials. See you next time.