Excel Formulas to Time into Decimal Hours ~ Easy Tutorial!!
Tags: excelformula, excelformulas
Published: 2021-05-06 02:10:49

---
title: Excel Formulas to Time into Decimal Hours ~ Easy Tutorial!!
published: true
date: 2021-05-05 08:19:15 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-time-into-decimal-hours/
---

So far we have learned how to convert **[decimal hours](https://geekexcel.com/excel-formulas-to-convert-decimal-hours-into-excel-time/), [minutes](https://geekexcel.com/excel-formulas-to-convert-decimal-minutes-into-excel-time/), [seconds into a valid Excel time format](https://geekexcel.com/excel-formulas-to-convert-decimal-seconds-into-excel-time/)**. Now in this article, we are going to see how to **convert a time into decimal hours in Excel**. 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)

[![Convert excel time into decimal hours](https://geekexcel.com/wp-content/uploads/2021/05/Convert-excel-time-into-decimal-hours.png)](https://geekexcel.com/excel-formulas-to-time-into-decimal-hours/convert-excel-time-into-decimal-hours/#main)<figcaption id="caption-attachment-35773">Convert excel time into decimal hours</figcaption>

## General Formula:

- To convert time to a number of hours, **multiply the time by 24** , which is the number of hours in a day. The formula is:

**=A1\*24**

## Syntax Explanations:

- **A1** – It represents the input time on your worksheet.
- **Multiplication (\*) **– In this symbol will multiply any two values or numbers.

## Practical Example:

Let’s consider the below example image.

- Here we have a list of times in **Column B**.
- Now we need to convert them into decimal hours.

[![Input Range](https://geekexcel.com/wp-content/uploads/2021/05/Input-Range-1.png)](https://geekexcel.com/excel-formulas-to-time-into-decimal-hours/input-range-43/#main)<figcaption id="caption-attachment-35771">Input Range</figcaption>

- Select any cell and type the above-given formula.

[![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-10.png)](https://geekexcel.com/excel-formulas-to-time-into-decimal-hours/enter-the-formula-119/#main)<figcaption id="caption-attachment-35774">Enter the formula</figcaption>

- Finally, press **ENTER**   to get the result out, if you need, drag the fill handle over range to apply the formula.

[![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result-9.png)](https://geekexcel.com/excel-formulas-to-time-into-decimal-hours/result-290/#main)<figcaption id="caption-attachment-35772">Result</figcaption>

- If the result of your formula is not displayed as a decimal, you need to change the cell formatting.

## Verdict:

In this article, you can get to know how to **convert a time into decimal hours in Excel**. I hope you enjoyed the blog post. If you have any **issue** regarding this article or any unresolved **query** , please comment in the **comment** box below. We will assist you.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Related Articles:

- **[Excel Formulas to Add Workdays to Date with Custom Weekends!!](https://geekexcel.com/excel-formulas-to-add-workdays-to-date-with-custom-weekends/)**
- **[Excel Formulas: Basic Timesheet Formula with Breaks ~ (Quick Formula)!!](https://geekexcel.com/excel-formulas-basic-timesheet-formula-with-breaks/)**
- **[How to Copy a Cell to Clipboard using Macros (VBA) in Excel 365?](https://geekexcel.com/how-to-copy-a-cell-to-clipboard-using-macros-vba-in-excel-365/)**
- **[Excel Formulas: Calculate dates overlap in days ~ A Complete Guide!!](https://geekexcel.com/excel-formulas-calculate-date-overlap-in-days/)**