Apologies for accidentally high-jacking a posted thread (Skip Vought) - Wondered why i did not see it displayed
I am a newbie, end used in BO (webI). No sure of the terminology correct
I want to add 3 days to a date and time, using the following criteria:-
Examples:
Adding 3 days
Mon 18/01/10 07:00:00 result should result 21/01/10
Mon 18/01/10 16:51:00 result should result 22/01/10
Sat 23/01/10 any time result should result 28/01/10
Sun 24/01/10 any time result should result 28/01/10
Mon 6/3 00:51:00 result should result 10/3
In short, anything after 1600hrs the calculation would start from the following day, weekends are not counted at all, and the calulation will be from the Monday. Any time before 1600hrs will count as day one)
Currently using in Excel, where D2 = "Call-over date & Time"
=WORKDAY(IF(OR(WEEKDAY(D2,2)>5,MOD(D2,1)>TIME(16,0,0)),WORKDAY(D2,1),D2),3))
I now using BO and generate a report, and wanted to add a variable column, rather than keep exporting report into Excel
Trying to compose variable for this complicated formula is above my level, I might be able to split the formula up, howver, I am stuggling with the MOD function, and how to enter it in BO
Any help, or pointing in the right direction, will be appriciated
Brian
I am a newbie, end used in BO (webI). No sure of the terminology correct
I want to add 3 days to a date and time, using the following criteria:-
Examples:
Adding 3 days
Mon 18/01/10 07:00:00 result should result 21/01/10
Mon 18/01/10 16:51:00 result should result 22/01/10
Sat 23/01/10 any time result should result 28/01/10
Sun 24/01/10 any time result should result 28/01/10
Mon 6/3 00:51:00 result should result 10/3
In short, anything after 1600hrs the calculation would start from the following day, weekends are not counted at all, and the calulation will be from the Monday. Any time before 1600hrs will count as day one)
Currently using in Excel, where D2 = "Call-over date & Time"
=WORKDAY(IF(OR(WEEKDAY(D2,2)>5,MOD(D2,1)>TIME(16,0,0)),WORKDAY(D2,1),D2),3))
I now using BO and generate a report, and wanted to add a variable column, rather than keep exporting report into Excel
Trying to compose variable for this complicated formula is above my level, I might be able to split the formula up, howver, I am stuggling with the MOD function, and how to enter it in BO
Any help, or pointing in the right direction, will be appriciated
Brian