Thanks! We'll email you
when relevant content is
added and updated.
I'm looking for a formula that will adjust a timestamp if the current timestamp is not within business hours. If the current timestamp is after 5:00PM the timestamp should increment the date portion by the correct number of days (Depending on Day of Week) and the time portion should be set to 8:00AM. Similarly if the timestamp is after midnight the date may not need to be adjusted but the time should still read 8:00AM
I have the logic worked out I just don't know how to write the code to put together an adjusted date (if needed) and a static time of 8:00AM
August 27, 2012 9:50 PM