Convert number in time format

Z

ZoranM

I have number representing minut, and how can convert this number in time
format
hh:mm.
I'm new in access world, please help

Thenk's
 
D

Douglas J. Steele

Assuming your value is lngMinutes, try:

lngMinutes \ 60 & ":" & Format(lngMinutes Mod 60, "00")

Note that I'm using \ (integer division) rather than / ("normal" division)
 
Top