Add 4 hours to Call Log Time 1

[ann1]

Hi Everyone
I need to create a formula that will add on 4 hours to the time that a call was logged to enable me to work out the percentage of calls completed within 4 hours regardless of SLA.

The problem is that if the call is logged at say 5:00 on the 1st then it needs to calculate that 4 hours will be 10:00 on the 2nd (say contract runs 8:00 - 6:00 Monday to Friday).

I have no idea how to even start this one ... I would appreciate any help!!
Thanks

 

[goranm]

Hi !

I think you can use the DateAdd function like this

if hour({YourDateTime}) >= 14 then
(
if weekday({YourDateTime}) = 6 then //friday
DateAdd ("h",66 ,{YourDateTime}) //will give you monday
else
DateAdd ("h",18 ,{YourDateTime})
)
else
DateAdd ("h",4 ,{YourDateTime})

/Goran

 

[ann1]

Hi ya
Thank you ... it works a treat!!