CAN ANYONE HELP ME WITH THE FORMULAS I NEED BELOW FOR C31, C32 AND C33?

Cell

B9 = START TIME AND DATE (EXAMPLE-USER ENTERS DATA) "10/15/07 08:00"

B10 = STOP TIME AND DATE (EXAMPLE-USER ENTERS DATA) "10/16/07 16:00"

C31 = FIRST SHIFT (BETWEEN 06:00-14:00) HOURS -NEED FORMULA TO GET "14"

C32 = SECOND SHIFT(BETWEEN 14:00-22:00) HOURS -NEED FORMULA TO GET "10"

C33= THIRD SHIFT(BETWEEN 22:00-06:00) HOURS - NEED FORMULA TO GET "8"

C34 = TOTAL RUN TIME -GOT THIS ONE AS =(B10-B9+(B9B10))*24
"32.00"

FORMATTED _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)