Mar 24, 2015 convert milliseconds to hh:mm:ss.000 excel Become a Registered Member (free) to remove the ads that appear in thread area. Click here to reset your password. Office Tab: Bring tabbed editing to Excel and other Office software, just like. To convert the milliseconds to time, the following formula can do you a favor.
![Convert Milliseconds To Seconds In Excel Convert Milliseconds To Seconds In Excel](http://i.ytimg.com/vi/fwMKbXI98tI/maxresdefault.jpg)
![Convert Convert](/uploads/1/2/5/4/125466752/256435300.png)
Without a macro, just use put a conversion formula in another column. Otherwise, you'll need a WorksheetChange macro that will monitor changes made to the cells and replace what is manually entered with the converted value.
This will perform the conversion on any number entered in Column A: Private Sub WorksheetChange(ByVal Target As Range) Application.EnableEvents = False If Target.Column = 1 Then If IsNumeric(Target) Then Target = Target / 1000 End If End If Application.EnableEvents = True End Sub.