I have a report that has 2 date/time stamp columns. The first is Admit Date (Patient Admitted) The second is Note Date (Admission assessment completed). What I need is a variable/alert to show the hours between the admission and the completion of the admission assessment, with the goal of Note Date being less than 8 hours. I have tried using DaysBetween but I need it in hours.
Using WEBI XI
Example: Admit Date/Time - 1/6/13 1:44 PM Note Date and Time - 1/6/13 5:20 PM