G Guest Oct 11, 2006 #1 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
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 Oct 11, 2006 #2 Assuming your value is lngMinutes, try: lngMinutes \ 60 & ":" & Format(lngMinutes Mod 60, "00") Note that I'm using \ (integer division) rather than / ("normal" division)
Assuming your value is lngMinutes, try: lngMinutes \ 60 & ":" & Format(lngMinutes Mod 60, "00") Note that I'm using \ (integer division) rather than / ("normal" division)
