mcelligott
Programmer
I am attempting to refine/re-build an if statement in excel VBA. I have not done a lot of date and time comparisons.
When the user clicks the button, Excel need to evaluate the following:
Note: the cell F2 contains a date only, not a time.
Is the current date & time between 2330 hours on F2 date-1 and 0730 hours on F2 date.
(ex: F2 = 4/8/2010, is the current date and time between 2330 hours 4/7/2010 and 0730 hours 4/8/2010?)
Any thoughts would be greatly appreciated.
Bob
When the user clicks the button, Excel need to evaluate the following:
Note: the cell F2 contains a date only, not a time.
Is the current date & time between 2330 hours on F2 date-1 and 0730 hours on F2 date.
(ex: F2 = 4/8/2010, is the current date and time between 2330 hours 4/7/2010 and 0730 hours 4/8/2010?)
Any thoughts would be greatly appreciated.
Bob