Converting Minutes to Hours

[James]

Howdy all,

I am trying to create a query that will convert minutes to
hours.

I notice that there is a function called CONVERT.

However in my help it says that I need the msowcf.dll
installed on my PC to use this function.

Well strangely I do have this .dll file but when I add the
function into a query it does not work.

Any Ideas???

Thanks

James

 

[Allen Browne]

To display a number of minutes as hours:minutes:

=[Minutes] \ 60 & Format([Minutes Mod 60, "\:00")

Note that this is a string represntation of the time, and cannot be used for
calculations. Unlike the built-in time functions, though, it does display
correct results for times longer than 24 hours.