Hi,
I have SLA's that run in a clients toolset, but they are not geared towards my companies agreed SLA's so I have to work them out by hand...or some spreadsheet trickery.
Is it possible to replace a date raised on the weekend (i.e. 7/05/2016 03:21) with the following workday at 0800 (i.e. 9/05/2016 08:00)
Thanks
You would have a line of code like this. If C is a range object that is the cell containing a date & time:
Please Login or Register to view this content.
Edit: Resolved.
Hi Jeff,
Thanks for the quick reply.
How would you tie that in with the previous code you helped with, which looked to change the time to 0800 the same working day if it occurred out of service hours (i.e. from 0001-0759 in the morning).
ThanksPlease Login or Register to view this content.
Last edited by susansmith32; 05-11-2016 at 10:18 AM. Reason: Resolved issue
You mean this last question is resolved? If not here is what I would do, but untested:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks