Divide the number of minutes by (24 hours X 60 minutes). (1440). Then format
the result as hours and minutes. Eg. For 15 minutes in a double numeric
variable called XMin, use
DisplayField = Format(XMin / 1440, "hh:nn")
Don't use "mm" but "nn". "mm" means 'months' to Access' Format() function.
You might look it up in the help file. Make sure to read the examples there.
Hope this helps,
Message posted via AccessMonster.com