|
Hi All,
Hope one of you nice people can help me out with this. I have a formula that calculates the time it takes for employees to input a job card. However, it currently only excludes weekends and I would like it to exclude holiday days.
Can anyone add to the code below, or advise me on how this can be done? I'm using Crystal Reports 10.
IF {VM_001_HDR.JC_RECEIVED_2} = {VM_001_HDR.JC_INPUT_2} THEN
(CDBL(MID({VM_001_HDR.JC_INPUT},1,2))+ ((CDBL(MID({VM_001_HDR.JC_INPUT},4,5))/100)/0.6))
-
(CDBL(MID({VM_001_HDR.JC_RECEIVED},1,2))+ ((CDBL(MID({VM_001_HDR.JC_RECEIVED},4,5))/100)/0.6))
ELSE
(
Local Numbervar x;
Local NumberVar Hrs := 0;
Local DateVar EvaluateDate := Date(Dateadd("d",1,{VM_001_HDR.JC_RECEIVED_2}));
Local NumberVar Days := DATEDIFF("D",{VM_001_HDR.JC_RECEIVED_2},{VM_001_HDR.JC_INPUT_2}) - 2 ;
For x := 0 to Days do
(
If DayofWeek (EvaluateDate) in [2,3,4,5,6]
Then Hrs := Hrs + 24
Else Hrs := Hrs;
EvaluateDate := Date(DateAdd("d",1,EvaluateDate));
);
Hrs
+
(CDBL(MID({VM_001_HDR.JC_INPUT},1,2))+ ((CDBL(MID({VM_001_HDR.JC_INPUT},4,5))/100)/0.6))
+
(24 - (CDBL(MID({VM_001_HDR.JC_RECEIVED},1,2))+ ((CDBL(MID({VM_001_HDR.JC_RECEIVED},4,5))/100)/0.6)))
)
|
IP Logged
