VBA time calculation
Activecell.Value = DateAdd("h", 16, Now())
"Nancy T." wrote:
I have created a command button. When I click it, I want it to get the
current time, add 16 hours to the current it, and enter that time in the
selected cell. I have spent way too much time trying to figure this out and I
am ready to pull my hair out. By the way, I am using Excel 2000. Any help
would be greatly appreciated!
|