How can I convert a number to time?

[ncimike3]

I would like to convert a number such as 15.25 to 3:15 pm. What is the easiest way to accomplish this? Thanks.

 

[pbaldy]

This should help:

http://office.microsoft.com/en-us/access-help/timeserial-function-HA001228925.aspx

Along with the Int() function and some math.

 

[CJ_London]

Another way is simply

Format(15.25/24,"medium time")