Adding dates and time...

[Cummins]

I have a table that I am storing into an array. I have an array FDate where I store 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?

 

[Derek Brown]

Is it not the same?
With dates/times held as the number of days since 01/01/1900, you only need to take one from the other.
(for example, mid-day on 30th October is 40846.50)