Integer To Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I format an integer that stores the number of minutes into HH:MM
format?

The field is called SMV.

Thanks,

Dave
 
I did it in a query first.

SELECT YourField, Int([YourField]/1440) AS Days,
Int(([YourField]-(1440*[Days]))/60) AS Hours,
[YourField]-(1440*[Days])-([Hours]*60) AS Minutes, [Days] & ":" &
[Hours] & ":" & [Minutes] AS Expr2
FROM YourTable;

Hope that helps!
 

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

Update Query 2
Converting list box column value to time 1
Calculating Time difference 6
Hourly Avg 8
RecordSet of Form 5
Combining Two Times 1
Storing time as integers 4
time formats 2

Back
Top