passing a time string with milliseconds into TimeValue()

**twd000** · 07-19-2009, 08:07 PM

I have a CSV file that I have imported using VBA. One column contains strings containing the elapsed time (timestamp of the collected data). I will need to perform various operations using these times, so I need to convert them to valid Excel Date-formatted values. Here are the relevant parts of my code:

Please Login or Register  to view this content.

I am getting type-mismatch error. The problem seems to be that my time string looks like this:

"00:00:01:21:992"
DD:HH:MM:SS:milliseconds

rather than this:
"18:30:12"
HH:MM:SS

is there any easy way to get VBA to understand that I have "extra" columns containing the Day and Millisecond information?

**shg** · 07-20-2009, 12:13 AM

That format is something Excel doesn't recognize as a valid data/time string. If that's how it's passed, you need to dissect it.

**Leith Ross** · 07-20-2009, 12:18 AM

Hello twd000,

Excel time values are computed by elapsed seconds within the day. There is no built-in format to convert the time string you have to a number that Excel can understand as a time value.

passing a time string with milliseconds into TimeValue()

LinkBack

Thread Tools

Rate This Thread

Display

passing a time string with milliseconds into TimeValue()

Re: passing a time string with milliseconds into TimeValue()

Re: passing a time string with milliseconds into TimeValue()

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions