Co-Authored By:

##### Asked by: Frusina Stoeckle

hobbies and interests video production# How do I convert days to hours in Excel?

**How to convert numbers to time format in Excel**

- Divide the numbers by 24 (there are 24
**hours**in a**day**). The formula can be as simple as =A2/24. - Select the cell(s) with the formula result, right-click andselect Format Cells from the context menu or press Ctrl+1.

Subsequently, one may also ask, how do I convert hours and minutes to hours in Excel?

To **convert hours and minutes** to **minutes**,you have to multiple the hh:mm value by 1440 (which is 24 [numberof **hours** in the day] multiplied by 60 [number of**minutes** in an **hour**]), AND make sure you set theformatting correctly for the both the hh:mm cells and the resulting**minute** cells.

**Another simple technique to calculate the duration betweentwo times in Excel is using the TEXT function:**

- Calculate hours between two times: =TEXT(B2-A2, "h")
- Return hours and minutes between 2 times: =TEXT(B2-A2,"h:mm")
- Return hours, minutes and seconds between 2 times: =TEXT(B2-A2,"h:mm:ss")

Similarly one may ask, how do I convert days to months in Excel?

**In case you want to get a month name rather than a number,you use the TEXT function again, but with a different datecode:**

- =TEXT(A2, "mmm") - returns an abbreviated month name, as Jan -Dec.
- =TEXT(A2,"mmmm") - returns a full month name, as January -December.

**How to convert numbers to time format in Excel**

- Divide the numbers by 24 (there are 24 hours in a day). Theformula can be as simple as =A2/24.
- Select the cell(s) with the formula result, right-click andselect Format Cells from the context menu or press Ctrl+1.