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