Tranform manhours table into t-sql /SSRS expression..

Hi,

I have this manhours table. It say that from the time of 6:00AM to 8:00AM the

value is 1.75 hrs, from 6:00AM to 10:00AM the value is 3.25, 6 to 12 PM 5:25,

then 6:00 to 2:00PM the value is 7 ,from 6:00 4:00PM 8.75 hrs the 6:00 to 6:PM

the value is 8.25 hrs. How do i make this in T-SQL codes and/or in SSRS

expression codes. I will be using the desired result in production man hours calculation.

I wanted to place the codes in SSRS parameter or inside the sql statement in dataset. THanks.



for example this is the first

shift.

Time Value

6 am* 8 am 1.75

6 am* 10 am 3.25

6 am* 12 pm

5.25

6 am* 2 pm 7

6 am* 4 pm 8.75

6 am* 6 pm 10.5



then second

the second shift start at 10:PM

10 pm*12 am 1.75

10 pm*2 am 3.25

10

pm*4 am 5.25

10 pm*6 am 7

for example: right now the time is 10:11 AM so the manhours falls in 3.25 hours.

jov