H2 Time format

[Michal]

Hi Garry,

Im trying to read the prices with a VB.net program using late binding. I am having problem however getting the time to display properly. What is the format that is being sent to the cell or better still how would I get the value of the cell to show in a vb.net code? Im confused as the cell is showing 0:2:23 yet in the formula bar it shows as 12:02:23 am ?????

any help would be appreciated.

Thank you

[Michal]

G2 is the cell I was talking about sorry not h2

[Michal]

Worked it out my self ...... smoke and mirrors

convert to time then separated the individual components of seconds and minute and hours and changed as needed to get it working.

Almost too hard .... who knows if it will even stand up

Michal

[Michal]

Nope didnt work ... any sugestions anyone ?

[GaryRussell]

Where xlws is your worksheet object and the time is in cell C2, try the following.

cellTime = Date.FromOADate(xlws.Cells(2,3).Value)

[Michal]

Hi Gary,

Im not sure if your suggestion works, however the solution was so simple its

objSheetsP.Range("D2").Text

the text is the key as it takes the actual formated value of the cell as you see it not as the cell is 'underneeth'

Thanks for your help anyway

Michal