# Convert Number to Time hhmmss in Excel (2 Suitable Ways)

Time calculation is a frequent need in Excel for several purposes. When importing a dataset or inputting data, it is very disturbing that we get the time values in decimal values. These values must be converted before further calculation and before representing the data for visualization. Else, there might be a ton of misinterpretation. In this regard, you have come to the perfect place. In this article, I will show you 2 suitable ways to convert number to time in hhmmss format in Excel.

## How to Convert Number to Time hhmmss in Excel: 2 Ways

Suppose, you have 8 numbers given as different dates. But, you need to convert these numbers to time in hhmmss format. Follow any of these ways to accomplish this.

### 1. Use TEXT Function to Convert Number to Time in hhmmss Format

You can use the TEXT function to convert a number into time in hhmmss format. Follow the steps below to do this.

📌 Steps:

• First and foremost, click on the C5 cell. Subsequently, insert the following formula. Next, press the Enter button.
`=TEXT(B5,"00\:00\:00")`

• As a result, you will get the time value in hhmmss format for the B5 cellâ€™s number. Following, place your cursor in the bottom right position of the cell. When the Fill Handle appears, drag it downward.

Consequently, you will get all the time in hhmmss time values for all the given numbers. For example, the result should look like this.

Note:

Here, the TEXT function returns the number in the exact format as given in the nd argument. So, the first two digits can not form a number greater than 24, the next two digits should not form a number greater than 60, and the last two digits canâ€™t form a number greater than 60. It would result in confusion and error.

### 2. Utilize Excel Multiplication Functionality

You can also use the Excel multiplication functionality for numbers in hours value or minutes value or seconds value.

#### 2.1 If the Number Means Hours

If the numbers are in hours value, follow the steps below to convert these numbers into time in hhmmss format.

📌 Steps:

• Now, suppose you have numbers in hours value. For doing this, you have to set the number format as Time.
• At the very beginning, select all the outcome cells that are C5:C12 here. Afterward, right-click on your mouse. Subsequently, choose the Format Cellsâ€¦ option from the context menu.

• As a result, the Format Cells window will appear. Subsequently, go to the Number tab >> choose Time from the Category: options >> choose the 13:30:55 option from the Type: options >> click on the OK button.

• At this time, click on the C5 cell and put the following formula inside the formula bar, and press the Enter button.
`=B5/24`

• As a result, the B5 cell number will convert into time into hhmmss format. Afterward, place your cursor in the bottom right position of this cell and drag the Fill Handle below upon its appearance.

Thus, you can see all your B column cell numbers are converted into time in hhmmss format. And, the outcome should look like the following.

#### 2.2 If the Number Means Minutes

Similarly, if you are given the numbers in minutes value, you can also convert them into time in hhmmss format. Go through the steps below to achieve this.

📌 Steps:

• Initially, follow the 2nd and 3rd steps from the previous way to set the format of the outcome cells as Time format.
• Afterward, click on the C5 cell and insert the following formula. Subsequently, press the Enter button.
`=B5/1440`

• Consequently, you will convert the number of the B5 cell into time in hhmmsss format.
• Afterward, place your cursor in the bottom right position of your cell. Subsequently, a black Fill Handle will appear. Following, drag it down to copy the formula for all the cells.

And finally, you will have all the numbers converted into time in hhmmss format. For instance, the conversion should look like this.

#### 2.3 If the Number Means Seconds

Just like the previous two ways, you can also convert the numbers in seconds value to time in hhmmss format by following the steps below.

📌 Steps:

• First, you have to customize your number format for the outcome cells. Follow the steps 2 and 3 from the 2.1 section to accomplish this.
• At this time, click on the C5 cell and write the following formula in the formula bar. Subsequently, press the Enter button.
`=B5/86400`

• As a result, you will get the time in hhmmss for the B5 cellâ€™s value.
• Afterward, place your cursor in the bottom right position of your cell. Now, a black Fill Handle will appear. Drag it downward to copy the formula for all the cells below.

Finally, you can see that you will have all numbers converted into time in hhmmss format and it looks like the following.

## Conclusion

To sum up, in this article, I have shown you 2 easy and quick ways to convert a number into time in hhmmss format in Excel. I would suggest you go through the full article carefully and practice each of the ways on your own. I hope you find this article helpful and informative. If you have any further queries or recommendations, please feel free to comment here.

## Related Articles

Get FREE Advanced Excel Exercises with Solutions!
Tanjim Reza

Md. Tanjim Reza Tanim, a BUET graduate in Naval Architecture & Marine Engineering, contributed over one and a half years to the ExcelDemy project. As an Excel & VBA Content Developer, he authored 100+ articles and, as Team Leader, reviewed 150+ articles. Tanim, leading research, ensures top-notch content on MS Excel features, formulas, solutions, tips, and tricks. His expertise spans Microsoft Office Suites, Automating Finance Templates, VBA, Python, and Developing Excel Applications, showcasing a multifaceted commitment to the... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF