refurbished
New Member
- Joined
- Oct 18, 2006
- Messages
- 3
Hello everybody!
Can anyone help me on a little problem?
I'm importing this text:
00:01:00
00:01:50
00:32:11
00:59:22
01:04:22
08:17:11
19:23:50
58:34:22
59:49:22
First 2 numbers (mm) are minutes, then seconds and then hundredth of seconds. But I can't figure out a way to import this data proprely!
I want to format this column like this: mmm:ss,00 so minutes would NOT be transformed in hours and seconds would show their split seconds, those hundredth of seconds. Like this:
mmm:ss.00
-------------------------
000:01.00
000:01.50
000:32.11
000:59.22
001:04.22
008:17.11
019:23.50
058:34.22
059:49.22
I've tried eveything on the format cells help but I just can't figure it out! It's very frustanting! Can anyone take a minute to enlight me? Please!
Thanks in advance!
Can anyone help me on a little problem?
I'm importing this text:
00:01:00
00:01:50
00:32:11
00:59:22
01:04:22
08:17:11
19:23:50
58:34:22
59:49:22
First 2 numbers (mm) are minutes, then seconds and then hundredth of seconds. But I can't figure out a way to import this data proprely!
I want to format this column like this: mmm:ss,00 so minutes would NOT be transformed in hours and seconds would show their split seconds, those hundredth of seconds. Like this:
mmm:ss.00
-------------------------
000:01.00
000:01.50
000:32.11
000:59.22
001:04.22
008:17.11
019:23.50
058:34.22
059:49.22
I've tried eveything on the format cells help but I just can't figure it out! It's very frustanting! Can anyone take a minute to enlight me? Please!
Thanks in advance!