Excel Formulas to Add Decimal Hours to the Time ~ Easy Tutorial!!
Tags: excelformula, excelformulas
Published: 2021-04-28 09:52:06

---
title: Excel Formulas to Add Decimal Hours to the Time ~ Easy Tutorial!!
published: true
date: 2021-04-27 08:45:43 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-add-decimal-hours-to-the-time/
---

As we know that the date and time in Excel are nothing but numbers. These numbers are formatted in such a way that they tell the exact time and date. The problem arises when we try to **add numeric or decimal hours to a time formatted value**. You can’t just add them using the sum operator or function. Let’s see them below!! 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)

[![Add decimal hours to time](https://geekexcel.com/wp-content/uploads/2021/04/Add-decimal-hours-to-time.png)](https://geekexcel.com/excel-formulas-to-add-decimal-hours-to-the-time/add-decimal-hours-to-time/#main)<figcaption id="caption-attachment-34826">Add decimal hours to time</figcaption>

## General Formula:

- If you want to add a given number of hours to a time, you can use the below formula.

**=[Time](https://geekexcel.com/how-to-use-time-function-in-excel-365/)+([Hours](https://geekexcel.com/how-to-use-hour-function-in-microsoft-excel-365/)/24)**

## Syntax Explanations:

- **TIME** –  In Excel, the**[TIME function](https://geekexcel.com/how-to-use-time-function-in-excel-365/)** will create time on your worksheet.
- **HOUR** – This function returns the hour of time value as a number between 0 (12.00 AM) to 23 (11.00 PM). Read more on **[HOUR Function](https://geekexcel.com/how-to-use-hour-function-in-microsoft-excel-365/)**.
- **Time** – It represents the input time from your worksheet.
- **Hours** – It specifies the decimal hours.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Plus operator (+)** – This symbol is used to add the values.
- **Division (/)** – It is used for dividing values or numbers.

## Example:

Refer to the below example image.

- First, we will enter the input times in **Column B**.
- Now we are going to add the number of hours to a time given in **Column C**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/04/Input-Ranges-33.png)<figcaption id="caption-attachment-34828">Input Ranges</figcaption>

- So, apply the above-given formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section and press the  **ENTER**  key.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/04/Enter-the-formula-25.png)<figcaption id="caption-attachment-34827">Enter the formula</figcaption>

- Finally, we will get the result in the selected cell.

![Result](https://geekexcel.com/wp-content/uploads/2021/04/Result-34.png)<figcaption id="caption-attachment-34829">Result</figcaption>

## Wind-Up:

From this tutorial, you can get some clarification on how to **add decimal hours to the given time in Excel**. If you have any other **ideas** or **question** , do share with us here in the **comments** section below. Thank you so much for visiting our site. Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[Excel Formulas to Add Days Exclude Certain Days of Week!!](https://geekexcel.com/excel-formulas-to-add-days-exclude-certain-days-of-week/)**
- **[Excel Formulas to Round Time to the Nearest 15 Minutes!!](https://geekexcel.com/excel-formulas-to-round-time-to-the-nearest-15-minutes/)**
- **[Formulas to Get a Number at Place Value ~ Simple Tricks!!](https://geekexcel.com/excel-formulas-to-get-a-number-at-place-value/)**