Can't answer this one in detail, as you have not provided much to go on, but I can at least give some pointers as to how to approach it.
Date/Time values in the Office applications have two parts; a long-int whole-number component representing the date, and a fractional component representing the time, where 0 is midnight and 0.5 mid-day and so on.
You need to check whether or not the date/time value is between the start and end times that you are interested in. This can be a little more involved than you might realise, as date-time values are numbers represented in text form in a very different way.
If the date/time value is within the range you are interested in, you'll need to add one or more to the whole number (date) component of the timestamp to take it to the next business day, truncating it using Int or somesuch to zero the time value. How much you need to add depends on when the next business day is, and that in turn depends on whether it is currently, say, Friday and the next business day is Monday. You can use the Weekday function to find out what the day number for the current day is.
Functions which may help: DateDiff and DateAdd, which can work with or return differences expressed in seconds, hours, minutes, days, weeks, months, quarters, and years; WeekDay, which returns a numeric value representing the day of the week; Date(), which the returns the current date; Now(), which returns the current date and time.
-Stewart
1
