X

How To Calculate Time In Excel-Simple Tutorial

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.

Categories: Excel Tips
Sandra: