Hour-Minute-Format

W

Wolfgang Voss

Hello Newsgroup,
how can I get a number of minutes in a query in hours and minutes (hh:mm) ?

Thank You.

Wolfgang
..
 
G

Graham R Seach

Wolfgang,

Use the Format() function:
SELECT Format(dteMyDate, "hh:nn") As myTime
FROM tblMyTable

....you see, the letter "m" is reserved for Months. To get minutes, you use
the letter "n".

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
T

Thomas Winkler

Hi,
how can I get a number of minutes in a query in hours and minutes (hh:mm)
Click to expand...
?

try to calculate the field in your query like this:

HH_MM: minutes \ 60 & ":" & minutes mod 60

HTH

Thomas
 
Top