How To Calculate Time In Excel-Simple Tutorial

Date:2021-5-3 Author:Sandra

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.

How To Calculate Time In Excel-Simple Tutorial
How To Calculate Time In Excel-Simple Tutorial

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.

How To Calculate Time In Excel-Simple Tutorial

Type =C2-D2 in cell E2 and press Enter key.

Remember to change the format of E2 into time.

How To Calculate Time In Excel-Simple Tutorial
How To Calculate Time In Excel-Simple Tutorial

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.

How To Calculate Time In Excel-Simple Tutorial
How To Calculate Time In Excel-Simple Tutorial

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.

How To Calculate Time In Excel-Simple Tutorial

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.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *