Hi,
A client needs to work out Due Date & Time for tickets adding hours not days which is what WORKDAY expects.
Examples for 4 hour SLA:
• Mon 30th Nov 2020 @ 15:50 then you need to add 4 hours = 1.5 hours used 30th and then 1.5 hours then next working day = SLA due 1st Dec 9:30
• Fri 5th Dec 2020 @ 16:00 add 4 hour SLA = 1 hour used Fri and then 3 hours left next working day = Mon 11:00 am it is due
If anyone can help that will be a huge help.
For Excel I found this formula but this does not work in Ragic
Examples for 4 hour SLA:
• Mon 30th Nov 2020 @ 15:50 then you need to add 4 hours = 1.5 hours used 30th and then 1.5 hours then next working day = SLA due 1st Dec 9:30
• Fri 5th Dec 2020 @ 16:00 add 4 hour SLA = 1 hour used Fri and then 3 hours left next working day = Mon 11:00 am it is due
In Excel you can do this but it does not work in Ragic:
WORKDAY(B1,INT(D1/8)+IF(TIME(HOUR(B1),MINUTE(B1),SECOND(B1))+TIME(MOD(D1,8),MOD(MOD(D1,8),1)*60,0)>
$K$1,1,0),$M$1:$M$1)+IF(TIME(HOUR(B1),MINUTE(B1),SECOND(B1))+TIME(MOD(D1,8),MOD(MOD(D1,8),1)*60,0)>$K$1,$I$1
+TIME(HOUR(B1),MINUTE(B1),SECOND(B1))+TIME(MOD(D1,8),MOD(MOD(D1,8),1)*60,0)-$K$1,TIME(HOUR(B1),MINUTE(B1),SECOND(B1))
+TIME(MOD(D1,8),MOD(MOD(D1,8),1)*60,0))
Thanks