Add Hours/Minutes/Seconds to a Datetime in Excel Office 365!!
Tags: addhoursminutessecon, kutoolsexceltutorial, kutools
Published: 2020-09-24 03:38:45

---
title: Add Hours/Minutes/Seconds to a Datetime in Excel Office 365!!
published: true
date: 2020-09-23 12:20:07 UTC
tags: AddHoursMinutesSecon,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/add-hours-minutes-seconds-to-a-datetime-in-excel-office-365/
---

## Add Hours/Minutes/Seconds to a Datetime:

In this article, we are going to see how to **Add Hours/Minutes/Seconds to a Datetime in Excel Office 365** using **Kutools**. Let’s get started!! 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.

## **Steps to Add Hours/Minutes/Seconds to a Datetime:**

To add hours/minutes/seconds to a datetime in Excel, do as below steps.

- Let’s consider the below date-time given in the **cell B2** and you need to **add 15 hours** , **130 minutes** , or **4500**  **seconds** to it.

![Example date-time](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-91.png)<figcaption id="caption-attachment-14477">Example date-time</figcaption>

- Kindly, follow the below steps.
- You have to **select a blank cell** where you want to print the result.
- Then, on the **Kutools**  **Tab** , **choose** the **Formula**  **Helper** option, **select** the **Date & Time** option, and **choose** the  **“Add hours to date”** option to add hours to the date.

![Choose Add hours to date option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-82.png)<figcaption id="caption-attachment-14478">Choose Add hours to date option</figcaption>

### Note:

- To **add minutes** to date, Go to the **Kutools**  **Tab** ,  **choose** the **Formula**  **Helper** option, **select** the **Date & Time** option, and **choose** the  **“Add minutes to date”** option.
- To **add seconds** to date, Go to the **Kutools**  **Tab** ,  **choose** the **Formula**  **Helper** option, **select** the **Date & Time** option, and **choose** the  **“Add seconds to date”** option.

- It will open the **Formula Helper dialog box**.
- You need to **select**  **Add**  **hours**  **to date** option from the **Choose a formula box** to add hours to the date.
- Then, you have to **click** the **button** given in the **Date time box to select the date**.
- In the **Number**  **box** , you need to give any number that you want to add as hours in the date-time.

![Formula Helper Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-42.png)<figcaption id="caption-attachment-14479">Formula Helper Dialog box</figcaption>

- Now, **hit** the **Ok**  **button** to get the result.

![Add hours to date-time](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Add-hours-to-date-time.png)<figcaption id="caption-attachment-14480">Add hours to date-time</figcaption>

### Add Minutes to Datetime:

- You need to **select a blank cell** and do as below steps.

![Choose Add Minutes to date-time](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/4-20.png)<figcaption id="caption-attachment-14481">Choose Add Minutes to date-time</figcaption>

- It will open the **Formula Helper dialog box**.
- In that dialog box, do as below steps shown in the screenshot.

![Formula Helper Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/5-9.png)<figcaption id="caption-attachment-14482">Formula Helper Dialog Box</figcaption>

- Now, you can see the result as shown in the below image.

![Add minutes to date-time](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Add-minutes-to-date-time.png)<figcaption id="caption-attachment-14483">Add minutes to date-time</figcaption>

### Add Seconds to datetime:

- You need to **select a blank cell** and do as below steps.

![Choose Add seconds to datetime option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/6-7.png)<figcaption id="caption-attachment-14484">Choose Add seconds to datetime option</figcaption>

- It will open the **Formula Helper dialog box**.
- In that dialog box, do as below steps shown in the screenshot.

![Formula Helper Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/7-5.png)<figcaption id="caption-attachment-14485">Formula Helper Dialog Box</figcaption>

- Now, you can see the result as shown in the below image.

![Add seconds to date-time](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/EXCEL_PCLZKiAGxo.png)<figcaption id="caption-attachment-14486">Add seconds to date-time</figcaption>

From the above steps, you can clearly learn how to add hours, minutes, seconds to a datetime.

### Note:

- You can also **subtract the number of hours, minutes, seconds from the date-time**. To do this, you just need to enter the negative numbers ( **for example, -90, -12, -400** ) into the **Number**  **input**  **box** of the Formula Helper dialog box.

### Added Information:

- If the cells are not in the date-time format, you need to change the cell format by right-clicking on the cell and **choose** the **Format**  **Cells** option from the menu.

![Choose Format Cells option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Choose-Format-Cells-option.png)<figcaption id="caption-attachment-14488">Choose Format Cells option</figcaption>

- It will open the **Format**  **Cells**  **dialog**  **box** , in the **Number**  **Tab** , **choose** the **Custom** section then, enter **m/d/yyyy h:mm:ss** in the **Type**  **box**.

![Format Cells dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Format-Cells-dialog-box.png)<figcaption id="caption-attachment-14489">Format Cells dialog box</figcaption>

## **A Brief Summary:**

In this article, you can understand the steps to **Add Hours/Minutes/Seconds to a Datetime in Excel Office 365** using **Kutools ** with examples. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!