convert seconds to minutes

[baserath]

please help i need to convert data that is being stored in number of seconds to minutes the conversion is for a report.
Thanks for your help

 

[RickSpr]

Divide by 60 Rick Sprague

 

[baserath]

The divide by 60 is understood. It is changing it from the decilam form on the minute to a form that reports it in the number of minutes and seconds 00:00. I know that 156 seconds is 2.6 minutes what I need reported is 2:36.

 

[RickSpr]

Oh, ok. Here's one way:

Public Function MinsAndSecs(Seconds As Long) As String
    Dim mins As Long, secs As Long

    mins = Int(Seconds / 60)
    secs = Seconds - (mins * 60)
    MinsAnd Secs = CStr(mins) & ":" & CStr(secs)
End Function
 Rick Sprague

 

[cmmrfrds]

Another way is to use the modulus operator or MOD in Access.

The seconds part of field = Seconds mod 60

Dim TheResult as string
dim Seconds as integer
Seconds = 156

TheResult = Int(Seconds/60) & ":" & (Seconds MOD 60)