How to Convert Time to Seconds/Minutes/Hours in Excel Office 365?
Tags: converttimetoseconds, kutoolsexceltutorial, kutools
Published: 2020-11-16 07:29:02

---
title: How to Convert Time to Seconds/Minutes/Hours in Excel Office 365?
published: true
date: 2020-11-15 15:37:39 UTC
tags: ConvertTimetoSeconds,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-convert-time-to-seconds-minutes-hours-in-excel-office-365/
---

In this tutorial, we will guide you to know the step-by-step instructions to **Convert Time to Seconds/Minutes/Hours in Excel Office 365** with **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Convert Time to Seconds:

Check this too: [Date & Time Functions in Excel Office 365](https://geekexcel.com/date-and-time-functions-in-microsoft-excel-365/)

To convert the time to seconds in Excel, follow the below steps.

- First, you need to **select the range** of time data that you want to convert to seconds.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-10.png)<figcaption id="caption-attachment-17010">Input Range</figcaption>

- On the **Kutools Tab, select** the **Content** option, **choose** the **Convert Time** option, then **select** the **Time**   **to Seconds** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-9.png)<figcaption id="caption-attachment-17011">Kutools Tab</figcaption>

- Now, a **prompt box** will pop-out to tell you how many cells have been converted to seconds. You need to **click** the **OK** button to close it.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-9.png)<figcaption id="caption-attachment-17012">Prompt box</figcaption>

- Then, you will see the converted seconds as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-7.png)<figcaption id="caption-attachment-17013">Result</figcaption>

## Steps to Convert Time to Minutes:

Here are steps to convert time data to minutes in the Excel spreadsheet, please do as follows.

- You need to **select the input range** of time data that you want to convert to minutes.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-10.png)<figcaption id="caption-attachment-17010">Input Range</figcaption>

- Go to the **Kutools Tab, select** the **Content** option, **choose** the **Convert Time** option, then **select** the **Time to Minutes** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-5.png)<figcaption id="caption-attachment-17014">Kutools Tab</figcaption>

- Then, a **prompt box** will pop-out to show you how many cells are converted to minutes. **Click OK** to close this box.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-9.png)<figcaption id="caption-attachment-17012">Prompt box</figcaption>

- Finally, you will see the converted data as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-5.png)<figcaption id="caption-attachment-17015">Output</figcaption>

## Convert Time to Hours in Excel:

If you want to convert time to hours in a worksheet, do as follows.

- You need to **select the range** of time data that you want to convert to hours.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-10.png)<figcaption id="caption-attachment-17010">Input Range</figcaption>

- Go to the **Kutools Tab, select** the **Content** option, **choose** the **Convert Time** option, then **select** the **Time to Hours** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-3.png)<figcaption id="caption-attachment-17016">Kutools Tab</figcaption>

- Then, a **prompt box** will pop-out to show you how many cells are converted to hours. **Click** the **OK** button to close this box.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-9.png)<figcaption id="caption-attachment-17012">Prompt box</figcaption>

- At last, you will see the output as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-3.png)<figcaption id="caption-attachment-17017">Result</figcaption>

### Note:

- All the above methods will replace the original time data with the conversion results.

## Steps to Convert Time to Seconds/Minutes/Hours & Save to Other Location:

To convert time to **seconds/minutes/hours** and **save** the **result to another location** , do as follows.

- First, you need to **select the range** of input that you want to convert to seconds/minutes/hours.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-10.png)<figcaption id="caption-attachment-17010">Input Range</figcaption>

- Go to the **Kutools Tab, select** the **Content** option, **choose** the **Convert Time** option, then **select** the **Convert Time** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/9-1.png)<figcaption id="caption-attachment-17018">Kutools Tab</figcaption>

- It will open the **Convert Time Dialog box.**
- You need to **select the conversion type** as you need.
- Then, **specify** the **destination range** in the **Save to** box.

![Convert Time Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/10-1.png)<figcaption id="caption-attachment-17019">Convert Time Dialog Box</figcaption>

- Now, **hit** the **OK** button. A prompt box will pop-out to tell you how many cells have been converted as shown in the below image.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-9.png)<figcaption id="caption-attachment-17012">Prompt box</figcaption>

- You need to **click** the **OK** button to close this box.
- Finally, you can see the converted results are displayed in the specified location.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/11.png)<figcaption id="caption-attachment-17020">Output</figcaption>

## Convert Time to Seconds/Minutes/Hours with Functions:

Kutools also provides functions to convert time to seconds, minutes, or hours. Let’s see them below.

- You need to **select a blank cell** to print the result.

![Select a blank cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/12.png)<figcaption id="caption-attachment-17023">Select a blank cell</figcaption>

- On the **kutools Tab, select** the **Kutools Functions** option, then in the **Date & Time** option, **select** any **one** of the Date & Time **options (TIME2HOURS, TIME2MINUTES, TIME2SECONDS).**

![Kutools Functions](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/13.png)<figcaption id="caption-attachment-17024">Kutools Functions</figcaption>

- Here, we select the **TIME2HOURS** function.
- It will open the **Function Arguments Dialog box**.
- **TimeData box** – You need to **select the cell** that contains input time.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/14.png)<figcaption id="caption-attachment-17026">Click OK button</figcaption>

- Then, **click** the **OK** button. You will see the result in the specified cell.
- You need to **drag the cell down** to fill the remaining cells.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/15.png)<figcaption id="caption-attachment-17027">Result</figcaption>

## Conclusion:

In this tutorial, we guided you to learn the steps to **Convert Time to Seconds/Minutes/Hours in Excel Office 365** with **Kutools.** Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [How to Insert or Delete a Worksheet in Excel Office 365?](https://geekexcel.com/how-to-insert-or-delete-a-worksheet-in-excel-office-365/)
- [How to Password Protect a Sheet in Excel Office 365?](https://geekexcel.com/how-to-password-protect-a-sheet-in-excel-office-365/)