Excel Formulas to Add Hours/Minutes/Seconds to a Datetime!!
Tags: excelformula, excelformulas
Published: 2020-10-20 12:15:58

---
title: Excel Formulas to Add Hours/Minutes/Seconds to a Datetime!!
published: true
date: 2020-10-20 08:40:58 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-add-hours-minutes-seconds-to-a-datetime/
---

## Formulas to Add Hours/Minutes/Seconds to a Datetime in Excel Office:

In this article, we are going to see how to use the **Formulas to Add Hours/Minutes/Seconds to a Datetime** in Excel Office 365. 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)
## Formula Syntax:

To add Hours/Minutes/Seconds to a Datetime in Excel, use the below formulas.

### Formula to add hours:

- The below formula is used for adding hours to a date time.

**=[TIME](https://geekexcel.com/how-to-use-time-function-in-excel-365/)([MOD](https://geekexcel.com/how-to-use-excel-mod-function-in-office-365-with-examples/)(15,24),0,0)+$B$2+[INT](https://geekexcel.com/how-to-use-excel-int-function-in-office-365-with-examples/)(15/24)**

### Example 1:

- In the below screenshot, we entered the input date in  **Cell B2.**
- Then, apply the formula given.
- Finally, it will show the results as shown in the below image.

![Add hours to date-time](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Add-hours-to-date-time.png)

### Formula to add minutes:

- Use the below formula to add minutes to a date-time in Excel Office.

**=[TIME](https://geekexcel.com/how-to-use-time-function-in-excel-365/)([INT](https://geekexcel.com/how-to-use-excel-int-function-in-office-365-with-examples/)([MOD](https://geekexcel.com/how-to-use-excel-mod-function-in-office-365-with-examples/)(130,1440)/60),MOD(130,60),0)+$B$4+INT(130/1440)**

### Example 2:

- Let’s consider the below screenshot to add minutes to a date-time.
- You need to enter the input as shown below.
- After that, apply the given formula in the selected area.
- Now, you will get the result as shown in the image.

![Add minutes to date-time](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Add-minutes-to-date-time.png)

### Formula to add seconds:

- To add the seconds to a date-time, use the below formula.

**=[TIME](https://geekexcel.com/how-to-use-time-function-in-excel-365/)([INT](https://geekexcel.com/how-to-use-excel-int-function-in-office-365-with-examples/)([MOD](https://geekexcel.com/how-to-use-excel-mod-function-in-office-365-with-examples/)(4500,86400)/3600),INT(MOD(4500,3600),MOD(4500,60))+$B$6+INT(4500/86400)**

### Example 3:

- In the below screenshot, we will enter the input dates.
- Then, apply the given formula in the selected formula bar.
- After applying the formula, it will display the result as shown below.

![Add seconds to date-time](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/EXCEL_PCLZKiAGxo.png)

## Explanations for Syntax:

- **TIME** – In Excel, this function is used to calculate the correct time from the input. Read more on the **[TIME Function](https://geekexcel.com/how-to-use-time-function-in-excel-365/)**.
- **MOD** – The[**MOD Function**](https://geekexcel.com/how-to-use-excel-mod-function-in-office-365-with-examples/) will return the remainder of the two numbers after division.
- **INT ** – The main purpose of the Excel **[INT Function](https://geekexcel.com/how-to-use-excel-int-function-in-office-365-with-examples/)** is to round a given integer number down to the nearest integer.

## Closure:

In this article, you will learn the **formulas for adding Hours/Minutes/Seconds to a date-time in Excel Office 365**. Kindly, share your feedback in the below **comment** section. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!!**