2 of 2 people found this helpful
There are some really nice VBA references on Chip Pearson's site. The VBA on the site is typically geared more towards usage from Excel, but obviously it being VBA should make it relevant to ProcessBook as well. Here is the page with the site's DST related VBA module:
I would have a look through there, and I'm sure you'll find something to help you out .
1 of 1 people found this helpful
Another alternative would be to use a PITime object instead of VB's Date, and then take advantage of the UTCSeconds property. The nice thing here is that UTCSeconds has taken care of the DST quirks and instead provided a very specific, unambiguous instant in time. Obviously the difference between 2 UTCSeconds, would itself be in seconds, which should be easy enough to convert to hours.