Thread: Hour addition
View Single Post
  #5  
Old July 27th 07, 04:36 PM posted to microsoft.public.access.modulesdaovba,microsoft.public.outlook.program_vba
Paolo
external usenet poster
  
Posts: 12
Default Hour addition
Hi Al,

Format(DateAdd("h", 8, Now), "hh:mm:ss")

HTH Paolo

"Al" wrote:

We have a program that trends our current plant steam usage and uses VBA
for applications. I'd like to use the do...loop and loop it until I reach
a time 8 hours away.

How do I add 8 hours to the currect time?

Thanks
Ads