Convert number in time format

G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Minutes into Hours and Minutes 4
Convert a number to a date time via unbound feilds 2
how to work with microsoft access 5
BARCODE IN ACCESS 4
Convert Integer to System Time format 3
Date conversion doesn't make sense 3
Calculating Difference Between Two Times in General Format 4
converting numbers to time 6

Top