LinkBack URL
About LinkBacks
How to convert text 1:26.459 ( 1 minute 26 seconds 459 milliseconds) to 0:01:26.459 time format (hour:minute:second.millisecond).
Thank you in advance,
How to convert text 1:26.459 ( 1 minute 26 seconds 459 milliseconds) to 0:01:26.459 time format (hour:minute:second.millisecond).
Thank you in advance,
Last edited by herukuncahyono; 06-18-2022 at 09:00 PM.
Assuming that is in cell A1, you could do this in B1:
=--("0:"&A1)
Apply a Custom Format to B1 to give the representation that you want, then copy down as required.
Hope this helps.
Pete
Use custom format h:mm:ss.000
string
Formula:
Please Login or Register to view this content.
or cell reference
Formula:Please Login or Register to view this content.
Hi, Pete
That's what i'm looking for..
Thank you
Thank you for the help
Glad to help, and thanks for marking the thread as Solved.
You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks