Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transfer info from excel - time field problem
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01378176
Message ID:
01378181
Views:
32
This message has been marked as the solution to the initial question of the thread.
>When I look at the value of a time field in excel it says 11:11 AM, however when I try to import this into my dbf file it reads .456777, what am I doing wrong?

It's just the way Excel internaly stores Date, Datetime and Time values. See http://www.cpearson.com/excel/datetime.htm for details.
You can post-process the time column
lnExcelTime = .456777
lnSeconds = ROUND(24*60*60 * lnExcelTime,0)
ltDt = {^2000/01/10 00:00:00} + lnSeconds
? SUBSTR(TTOC(ltDt,3),12)
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform