If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Convert number to time
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" |
Thread Tools | |
Display Modes | |
|
|