How do I make a field to display minute/seconds (runners time)

[Kelly]

Our students have to run a mile and 1/2 and I need to put the minutes and
seconds they ran in a field. I then want to use that minute/second time to
make a pivot chart to show their progress.

How do I make a minute/seconds field? I've tried the date function stuff
but either I'm doing it wrong or it doesn't work. Could really use some
help. Thanks!!!

 

[Rick B]

Do a search and read previous posts. This is a very common question.

The most common answer is to create a numeric field and enter the total
seconds (or tenths of second or hundredths). Then, in your forms, reports,
and queries you can divide the entry by 60 to get the number of minutes,
insert a colon, then display the remainder.

Do a search and you should find several examples. the following is an
example of how to store minutes, then print minutes and seconds. The
concept is exactly the same...

Displaying minutes as Hours:Minutes (X:XX)
=[SomeFieldName]\60 & Format([SomeFieldName] Mod 60, "\:00")