I need to break apart a timespan/duration value.
I need to calculate the availability of resources by hour of the day.
I have a call for service at 0945 that last until 1030 unit = E52
I have a call for servce at 0930 that last until 1015 unit = E53
I have a call for service at 1030 that last unitl 1230 unit = E53
query to show the following
% of availabilty for said unit by hour of day
0900 to 1000 available 75% of the time for E52
0900 to 1000 available 50% of the time for E53
1000 to 1100 available 50% of the time for E52
1000 to 1100 avaialble 25% of the time for E53
1100 to 1200 available 0% of time for E53
1200 to 1300 available 50% of the time for E53
all times are actual DTS with dates, hour, minutes, seconds and can transcend past midnight.
So in essence I am trying to calculate the availablity of a fire engine in your neighborhood. How often is it our of service on a call by hour of day.
View Complete Post