Minutes and Seconds format for record in Database

[vegetamaker]

Good evening. First at all thanks so much for your time.




Well, I spent hours looking in google an answer for my problem, but without luck (I must admit that I am very novice with Access).


I am doing a football (soccer) database and I must save the times for differents situations (you know, goals, faults, etc). The problem is the format of the data. I need that it show, per example, 71:28 instead 1:11:28... but the format only let me use 59 minutes. I managed to do it in Excel with [mm]:ss but don't look work in Access.


I guess I could program a query to calculate it and show it in minutes format, but it isn't exactly what I want. I want save it exactly like said before (71:28).


I thought I could save it as text, but then I couldn't do correct sorts. Other solution, a weird and not very good one, is save them like number (71'28) but it will not work later if I need calculate total seconds per example.


Any tips will be welcome.


Thanks!

[CJ_London]

minutes (and seconds) cannot be greater than 60 - just has hours cannot be greater that 24

you will need to calculate the number of seconds and use mod and \ to determine the relevant parts.

time in mins and secs: datediff("s",time1,time2) mod 60 & ":" & datediff("s",time1,time2) \ 60

it will be a text output so sort on

datediff("s",time1,time2)

[vegetamaker]

Thanks for your time Ajax. I will try it ^^