Convert number to time

I have field with numbers like 28815. How do I convert this number to
8:00:15 AM time format.
Is there an easy way to convert numbers to time?

Floyd

Floyd Forbes wrote:
I have field with numbers like 28815. How do I convert this number to
8:00:15 AM time format.
Is there an easy way to convert numbers to time?

Floyd
Could you show a few more examples? For instance, how is a PM time
represented?

With this specific example, you would use string functions to parse out the
hours and minutes and use timeserial to convert it to time:

MyTime: TimeSerial(Mid([fieldname],3,1),right([fieldname].2),0)

but this will likely not be adequate for all your data.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"