Is there anyway in Access to display accumulated minutes like in Excel when using the [mm]:ss format?

Sorry Ben, don't actually understand what you mean. What are you trying to do?

Clive Astley

Hi Clive,

Thanks for replying, I have some data which has to be displayed in minutes and seconds format ("nn:ss"). The other day some of the data was over an hour, and with the "nn:ss" format the data read 07:49, I can't use "01:07:49" to display the data, so basically I want the data to appear as 67:49. In excel entering the format "[mm]:ss" would do this, I just wanted to know if there was an equivelant easy way of doing this in Access.
It's not often that this will occur so it's not a big deal, I guess if the worst comes to the worst I could create a custom formula but it just seems a bit overkill.

Ben

Ben, I'm still not certain what your original data format is. The following will display a number of seconds in the format you need. Does it help?

Public Function Conversion(myInput As Integer) As String
  Dim myMins As Integer
  Dim mySecs As Integer
  myMins = Int(myInput / 60)
  mySecs = myInput - myMins * 60
  Conversion = myMins & ":" & mySecs
End Function

Clive Astley