What I am trying to do is return the number of business hours between two date/times. I have a code that will return the amount of business days between the two, but I can’t get it to display in hours. I tried to just replace where it says days, to hours but it didn’t work. Any ideas?
I have the following code.
Days :=@Text(@BusinessDays( DateReceived; OriginalDate; 1:7; [01/01/2007] : [01/15/2007] : [02/19/2007] : [05/28/2007] : [07/04/2007] : [09/03/2007] : [11/22/2007] : [12/25/2007] : [01/01/2008] : [01/21/2008]: [02/18/2008] : [05/26/2008] : [07/04/2008] : [09/01/2008] : [11/20/2008] : [12/25/2008])-1) ;
@If(DateReceived = “”; " ";DateDispositioned= “”; " "; Days)