milliseconds

[chunyih]

Im doing an event where time calculation is needed.
Right now I'm using Datediff to find out the difference in time in SECONDS.
I need to round down to the more precise Millisecond but the help file only shows the former available.
Need some help to make it be able to calculate in milliseconds too.. anyone?

 

[chunyih]

right now the format for my start and end time is
hh\:nn\:ss

and input mask is
00:00:00

so i calculate seconds difference.

what im trying to do now is...
hh\:nn\:ss\:xxx (something that means milliseconds?)

and input mask being
00:00:00:00
for hours, min, sec, millisec

so i can calculate the difference in milliseconds.

 

[RuralGuy]

How are you capturing and storing the milliseconds?

 

[chunyih]

right now my timing is typed in a form.
the columns are

Participant, StartTime, Endtime.
so i fill in
eg. Person A, 01:10:15, 01:15:20.

a query returns the difference of 300 sec
Sec: DateDiff("s",[StartTime],[EndTime])

a report prints it via FORMAT / 60 to show 5 mins
and MOD 60 to show 5 secs

i want the query to use base unit in milliseconds instead of seconds, any way that is possible? i found come stuff using VB but it's a little confusing to implement...

 

[RuralGuy]

Have you considered using a separate integer field for the milliseconds?

 

[chunyih]

yes i would use a seperate field if theres really no help available..
so far i guess there isnt...
well, thanks anyway!