How to Convert Days to Hours in Excel – 3 Easy Methods

Written by Musiha Mahfuza Mukta

Last updated: May 7, 2024

This is the sample dataset.

Method 1 – Using the CONVERT Function to Convert Days to Hours

To use the CONVERT function:

Steps:

Select a new cell (F5, here) to see the Duration in Hours.
Enter the formula.

=CONVERT(E5,"day","hr")

The CONVERT function converts E5 values from Day unit to Hour unit.

Press ENTER to see the result.

Copy the same formula using relative cell references:
Select F5. A square box will be shown at the bottom-right corner of the cell F5. It is the Fill Handle icon. Click and drag it down to F11.

This is the output.

Read More: How to Convert Hours to Decimal in Excel

Method 2 – Applying a Generic Formula to Convert Days to Hours in Excel

Steps:

Select a new cell (F5, here) to see the Duration in Hours.
Enter the formula.

=E5*24

E5 value is multiplied by 24.

Press ENTER to see the result.

Drag the Fill Handle to AutoFill the rest of the cells: F5:F11.

This is the output.

Read More: How to Convert Hours to Days in Excel

Method 3 – Using the TEXT Function to Convert Days to Hours in Excel

Use the TEXT function:

Steps:

Select a new cell (F5, here) to see the Duration in Hours.
Enter the formula.

=TEXT(E5,"[h]") & " Hours"

Press ENTER to see the result.

Formula Breakdown

Here, the TEXT function will format text with a given format.

E5 – the cell value is formatted.
“[hr]” is the value to be converted into hours.
” Hours” declares hours as a text. The additional space before the Hours is used to keep space between the value and the unit name.
The Ampersand (&) joins the output and Hours.

Drag the Fill Handle to AutoFill the rest of the cells: F5:F11.

This is the output.

Read More: How to Convert Hours to Minutes in Excel

Practice Section

Practice here.

Download Practice Workbook

Download the practice workbook here:

Converting Days to Hours.xlsx

Related Articles

<< Go Back to Convert Time to Hours | Time Conversion | Date-Time in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!

SaveSavedRemoved 0

Tags: Convert Time to Hours in Excel

Musiha Mahfuza Mukta

Musiha Mahfuza Mukta is a marine engineer who loves exploring Excel and VBA programming. To her, programming is a time-saving tool for dealing with data, files, and the internet. She's skilled in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. With a B.Sc in Naval Architecture & Marine Engineering from BUET, she's shifted gears and now works as a content developer. In this role, she creates techy content exclusively focused on Excel... Read Full Bio

We will be happy to hear your thoughts

Leave a reply Cancel reply

Submit Excel Problem