Can access recognize fractions of a second?

[Hswift]

Hello,



I have a .CSV file on my computer (that I have not imported into Access yet) with data that is structured like this:

h,m,s,ms
21,36,11,146
21,55,38,012
22,45,27,884

Here is what the column header stands for
h=hour
m= minute
s= second
ms= millisecond (which is 1/1,000 of a second)

Is there a way to import this data into Access so that Access understands the "ms" column is 1/1000th of a second?

I need Access to understand what the "ms" column is because I will be subtracting from this "ms" column, which could lower the "s" column. For example, the rows mention above would need to appear as follows if i subtracted 20 from the "ms" column (notice that this lowers the middle row's "s" column from 38 to 37).

21,36,11,126
21,55,37,992
22,45,27,864


Thanks!

[ItsMe]

The short answer is, no. The .NET framework offers classes to manage timespans and dates with milliseconds. However, Access does not. You can get a Date by using a sum of milliseconds. However, a date and adding seconds to milliseconds are two different things.
https://support.microsoft.com/en-us/kb/210276

Why not just use integers to get a sum of milliseconds and then cast the result to a text string? You can grab the characters to the left of the text string and place them into your Seconds element. The three characters on the right will be your milliseconds.
https://msdn.microsoft.com/en-us/lib.../gg251556.aspx

You could use the split function to analyze the various elements of your h,m,s,ms thing. Maybe place the result into a table or a collection or a dictionary or ...
https://msdn.microsoft.com/en-us/lib.../gg278528.aspx