How to convert time into speed?

[Hello1]

Couldnt think of a better title for the thread. However, I need help in next case.


I made a query "qryResults" which contains some results about races (in the screens is the smaller version of it). I have 3 fields, the length of the race track in kilometers, driving time in minutes (its the drivers time which he needed to finish the race) and the calculated field average speed of the driver during the race the calculation you can see on the screens i attached. Anyhow, it works fine but the problem is that I want the field "DrivingTime" to be more detailed. Instead only minutes to be written something like 01:31:54. I tried to make that field date/time and have put the format to be "long time" but the calculation doesn't work then, well guess date/time isn't meant for that anyway. Tried for a while now but just cant figure it out :/
If anyone has an idea (guess here math needed more ) please share, thanks!

[June7]

Converting minutes to a clock time display is actually a string result, not a date/time value.

Bing: Access convert minutes to hours and minutes

https://bytes.com/topic/access/answe...-access-2000-a

[ranman256]

I have a function to do this,

   'USAGE:  ElapsedTimeAsDate(655)

Public Function ElapsedTimeAsDate(ByVal pvSecs)
Dim vTxt, vHr, vMin, vSec
Dim iNum As Long

'60 sec = 1 min  60 sec
'60 min = 1 hr 3600 sec

  'hrs
iNum = pvSecs \ 3600
if inum > 0 then
    vHr = format(iNum,"00")
    pvSecs = pvsecs - (inum * 3600)
end if
    
   'mins
iNum = pvSecs \ 60
if inum > 0 then
    vMin = format(iNum,"00")
    pvSecs = pvsecs - (inum * 60)
end if

vSec =  pvSecs 
ElapsedTimeAsDate= vHr & ":" & vmin & ":" & vsec
End Function

[Hello1]

Hey June thanks!
However, I found something else, and it works just like I want it.

Edit: just saw your post after posting mine ranman, thanks but im not yet into programming. Will definitely check it when i get spare time. Thanks again guys.