Adding an array of Dates to an Array of Times.

I have a table that I am storing into two arrays.
One array, FDate,stores a date and another array, FTime, where I store times.

FDate is formatted as m/dd/yyyy Hh:Mm:Ss
Ftime is formatted as Hh:Mm:Ss

I know in excel that you can add and subtract dates and times. How do you accomplish the same task in VBA?

Format does not equal value. Use cdbl(). e.g.

Please Login or Register  to view this content.

Depending on the type of values stored in FDate and Ftime the answer to this question will varry, but it could be generally done by

Please Login or Register  to view this content.