You are correct, Reeza, I was missing a subfolder in the name.  Now it works and all is well.  Thanks very much. ... View more

Thank you for your responses.  Previously, when I wasn't "building from variables", the Excel file would just open up with the name I had created i.e. DAD_DQ_Inst5555.xlsx.  But now that I am building the file name from variables I get an error message that "physical file does not exist".  Why would that be and how do I correct it?   Thanks. ... View more

Thanks to the both of you for your speedy response!  Ballardw's solution works exactly as I required, thank you so much!  Have a great weekend everyone! ... View more

Hi Reeza   Finance wants to know how many minutes per day utilized by patients in the ICU per each day for a case costing exercise.   So whereas occupancy allows us to create a record per day between admit and discharge date, I would like minutes related to the icu admit date/time per each day.   So, for the first example, there would be 3 days showing (Apr 1 to 3) and the minutes would be calculated as 0800 hours to midnight (960 minutes) for April 1 because the patient entered the ICU at 0800, then the full day of April 2 = 1440 minutes, then day 3 would be 00:01 to 1500 hours (900 minutes) where 1500 is when they are discharged from ICU.  These would be 3 rows of data for the same chartno/acctno.     Thanks.         ... View more

I think you are right but not sure how to accomplish this.  I basically want an occupancy report but instead of just dates I would want date/times so that I can calculate total minutes per each day of occupancy in the ICU.   The original report for occupancy using ICU dates is a do loop where do=icuadmdate to icudisdate-1;  In this instance I assume I want to first create the datetime fields and then create the calculation for the minutes.  I'm just not clear how I do that.       ... View more