reading cells of date and time format from excel file and writing them in a file

[shrey]

hiii, i m able to read excel using COM component but the column which has date format gives a scientific value on reading ( Eg. 5:30 gives .2291666666667)



Dim WithEvents xlbook As Excel.Workbook
xlbook = GetObject("c:\master.xls")

selectedsheet = textbox1.text
Dim ws As Excel.Worksheet = CType(xlbook.Worksheets(selectedsheet), Excel.Worksheet)

ws.Cells(irow, icol).Value()

help...