Figuring available minutes based on dates

[sorchard2000]

Hello!
Crystal 8.5--SQL server

I am trying to do a complicated report. I have copied a standard crystal report provided by our software vendor and am trying to modify it to our needs.
I work in a surgery dept where we need to track surgery room utilization as a percent used. I currently have all the numbers of how many cases we did and how many total minutes the cases took. End user puts in date range which can be anywhere from 1 day to months at a time. The only thing I lack is the number of minutes the surgery room is available based on the end user date input. This seems difficult to me since the date range (entered by end user) constantly varies. Once I get the total number of available minutes, I can then figure out percentage of utilization of each surgery room

Current data:
OR 1 shift 1 (7am-3pm) 7000 minutes used
OR 1 shift 2 (3pm-11pm) 1000 minutes used
OR 2 shift 1 (7am-3pm) 6500 minutes used
and so on.

Desired Output:
OR 1 shift 1 (7am-3pm) 7000 minutes used 65% utilized
OR 1 shift 2 (3pm-11pm) 1000 minutes used 35% utilized
OR 2 shift 1 (7am-3pm) 6500 minutes used 70% utilized
and so on.

I hope I have explained it adequately.

Thanks ahead for any help given.

sorchard2000

 

[sorchard2000]

Sorry, I need to modify my request somewhat:
Instead of figuring the amount of utilization per surgery room (OR 1, OR 2, etc...), I think I need to make this easier and as follows:
I need to modify the report so that it figures percent utilized based on day of the week. And since # of days of the week vary per month (last month there were 4 Mondays in the month; in May there are 5 Mondays per month.), I am puzzled on how to figure time available per day of week. There are 10 surgery rooms in our dept so the available minutes need to include all 10 rooms.

Current data:
Monday shift 1 (7am-3pm) 7000 minutes used
Monday shift 2 (3pm-11pm) 1000 minutes used
Tuesday shift 1 (7am-3pm) 6500 minutes used
and so on.

Desired Output:
Monday shift 1 (7am-3pm) 7000 minutes used 65% utilized
Monday shift 2 (3pm-11pm) 1000 minutes used 35% utilized
Tuesday shift 1 (7am-3pm) 6500 minutes used 70% utilized
and so on.

Hope that helps!
sorchard2000

 

[sorchard2000]

I think I have solved this problem on my own.
Thanks anyway!

sorchard2000