Thread: Hour addition
View Single Post
  #2  
Old July 27th 07, 04:28 PM posted to autodesk.autocad.customization.vba,microsoft.public.access.modulesdaovba,microsoft.public.outlook.program_vba
fredg
external usenet poster
 
Posts: 1
Default Hour addition


"Al" wrote in message
9.11...
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


I have no idea what you mean by using a do..loop for this purpose,
but to add 8 hours to the current time, use:
=DateAdd("h",8,Now())

Fred


Ads