## How to convert milliseconds to time in Excel?

As we all known, one second equals 1000 milliseconds between the time unites, this article, I will talk about how to convert milliseconds to hh:mm:ss time in Excel.

**Convert milliseconds to hh:mm:ss time with formula**

#### ** Convert milliseconds to hh:mm:ss time with formula**

To convert the milliseconds to time, the following formula can do you a favor:

Please enter this formula into the blank cell where you want to output the result:

**=CONCATENATE(TEXT(INT(A2/1000)/86400,"hh:mm:ss"),".",A2-(INT(A2/1000)*1000))**, and then drag the fill handle down to the cells that you want to apply this formula, and all milliseconds in the cells have been converted to time, see screenshot:

### Best Office Productivity Tools

**Supercharge Your Spreadsheets： Experience Efficiency Like Never Before with Kutools for Excel**

**Kutools for Excel boasts over 300 features, ensuring that what you need is just a click away...**

Supports Office/Excel 2007-2021 & newer, including 365 | Available in 44 languages | Enjoy a full-featured 30-day free trial.

#### Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!