>I'm importing an Excel Worksheet into VFP7 SP1. I've tried the import command and office automation, but I cannot get time values from Excel.
>
>As an example my Excel Cell contains
10:45:00 PM this impots into VFP as
.4479166667 and it doesn't seem to matter what time format is used in Excel.
That would be a fraction of a day. Multiply this by 86400 (seconds per day), and you have the number of seconds since midnight.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)