Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Transfer info from excel - time field problem
Message
De
05/07/2011 23:10:45
Jill Derickson
Software Specialties
Saipan, CNMI
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
01378176
Message ID:
01517373
Vues:
41
Thank you, thank you, THANK YOU!!!

A gift that keeps on giving ;-)!


>>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)
>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform