Format field for Min:Sec.000

[JimO]

I have a field that contains lap times from an auto race. I need to format the field to accept a time such as 1:15.264 (1 minuet, 15 seconds & 264 tenths of a second). I have tried using n:ss.000 but I am unable to enter data.



I wish to use this to calculate lap speed using this field and a field of the lap distance.

Jim O

[CJ_London]

try

n:ss.fff

see this link

https://msdn.microsoft.com/en-us/lib.../jj737650.aspx

it applies to 2013 but may work in 2010

also assumes your field is a date/time field

[JimO]

I looked at the link but have not been able to get anything to work.

Do What should I set the datatype to? I have tried Date/Time and Number, & format to m:ss.000 or n:ss.000 both with no success. Access wants to change the format
to /m.ss.000 and I think it is looking for a date.

Jim O

[CJ_London]

have you tried the format I suggested from the link?

as stated, is you are using 2010, it may not work since the link refers to 2013

for it to work field would need to be date/time

However I've just had a play around - the fff does not work in 2010. What does work is

to have a datatype double or long
set the format to 0\:00\:000
and the input mask to 0:00:000



depending on your requirements you may need an algorithm to convert the number into number of milliseconds and I guess you'll also need some validation to ensure the seconds part cannot exceed 59. Don't forget this is stored as a number so ranking is OK, but the difference between two times is not a simple deduct one number from the other

[JimO]

That is showing the value as h:mm:ss.000. If I enter 1:15.222 is shows it as 1:15:222.000, I need to show only minutes and seconds.
I can work around the math if I can just get the value displayed.

Jim O

[CJ_London]

please clarify

a) you initially said -I need to format the field to accept a time such as 1:15.264 (1 minuet, 15 seconds & 264 tenths of a second. Now you are saying I need to show only minutes and seconds which is it?
b) before suggesting it, I tried it and it worked for me, so think you have not copied correctly - please copy and paste what you are actually using

c) confirm you are using a long or double data type

[JimO]

I have played around with it and it seems to be OK now. Sorry if I misled you, I do need it to show minutes, seconds and fractions of a second.
I thank you for your time and expertise on this issue.

Jim O