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

Hi, we will discuss these requirement and see if we can incorporate this into our future release.