VBA Dates & Cell Dates
On Tue, 15 Jul 2008 06:53:02 -0700, Graham Y
wrote:
Thanks Ron
I think this is actually a rounding or conversion issue somewhere in the
process, as when I initialize the 'total' variables to 1 second and then
subtract 1 second at the end of the loop, my totals all match. ( I have a
'grand' total and three 'section' totals, which were not matching, hence
finding the bug.)
I don't understand what you've written. But the one day difference between VBA
and Excel disappears on 1 Mar 1900. Since I don't really know how you are
attacking your problem, I'm afraid that's all I can give you. Hopefully you'll
be able to get things working to your satisfaction.
Best,
--ron
|