Convert Date/Time array to a integer array

Hi All,

I can't find any information on the net or this forum to find out how to do this..

I have an array: d() as Date
It has a whole pile of different times stored in it. eg. 12:01am, 5:21pm etc.
I need to convert this to seconds and store it in an array so that I can dump the data onto a worksheet.

Any ideas on how I go about achieving this?


Regards,

bradja

Hi patel45 thank you for your response.
Doing some testing myself I was able to fix this.

I forgot that "time" is stored as a fraction of a 24-hour day.
So I just amended the time array like this:

Please Login or Register  to view this content.

I then dumped this data into the column and it achieved the result I was after =]