When a user faces any problem, help desk creates a ticket for him/her and put a time stamp on it. We want to track...
how many business hours took to solve a problem. Our Business hours are 6:00 AM to 6:00 PM, from Monday to Friday. So if a ticket has been reported outside of this window then Adjusted Time should be next day i.e. Next business day at 6:00 AM.
@If(OpenDate = ""; @Return(""); @Success); WeekDay := @Weekday(OpenDate); DayAdjust := @If( WeekDay = 6 & @Hour(OpenDate) >= 18 ; 3; WeekDay = 7; 2; WeekDay = 1; 1; @Hour(OpenDate) >= 18; 1; 0); TimeAdjust := @If (@Hour (OpenDate) < 6 | DayAdjust != 0; "06:00 AM"; ""); AdjDate := @Text(@Adjust ( @Date(OpenDate) ; 0; 0; DayAdjust; 0; 0; 0)); @If( DayAdjust = 0 & TimeAdjust = ""; OpenDate; @TextToTime(AdjDate + " " + TimeAdjust))