Multi color Range Bar based on values in ssrs 2008 -

i designed range bar using ssrs 2008. scenario having issue follows:

my range bar based on "activity name", start date & time, end date & time.

eg: activity starts on 1st april @ 5am , ends @6pm. requirement range bar should show 5am 10am in 1 color, 10 2 pm in 1 color , 2pm till 6 pm in color.

basically trying show shifts involved in completing activity. hope requirement clear. please help.

it's hard visualize chart if displaying total number of activities (activity name) in 1 bar , data has date/time field, can use charts's series properties' fill property.

on chart values, click drop-down value series , go fill tab. color expression, you'll want like:

=iif(format(fields!yourdatetimefield.value, "hh") >= 5 , format(fields!yourdatetimefield.value, "hh") < 10, "blue",    iif(format(fields!yourdatetimefield.value, "hh") >= 10 , format(fields!yourdatetimefield.value, "hh") < 13, "purple",   iif(format(fields!yourdatetimefield.value, "hh") >= 14 , format(fields!yourdatetimefield.value, "hh") < 18, "red", "orange"))) 

this color activities between 5 , 10 blue, 10 , 2 om purple , 2pm , 6 pm red - outside these ranges orange.