User Profile

JackC051

Copper Contributor

Joined 3 years ago

2 Posts

View All Badges

User Widgets

Recent Discussions

Re: Format column of text data to time
HansVogelaar Hans, thanks for your suggestions. I used number of formulas, taking groups of 2 characters, adding ":", to come up with the form "mm:ss.sss", then formatted the column as "time".
Aug 18, 2023 Place Excel
623Views
0likes
0Comments
Format column of text data to time
I have a column of text data in the form of "1234.789" that I would like to convert to to a time format such as: 12 (minutes) : 34 (seconds) . 789 (milliseconds). I tried using a custom format but, was unsuccessful. Any ideas out there? I'm using Microsoft Office Pro 2019.
Aug 17, 2023 Place Excel
excel
695Views
0likes
2Comments

Recent Blog Articles

No content to show