Total time vs hours per shift

[WILSONLA001]

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+(B9>B10))*24
"32.00"

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

 

[Pete_UK]

Do a Google search for the thread "Dividing a time span into shifts -
overlapping days" from Feb 2006 in this group. Very similar problem to
yours, so the solutions should be applicable.

By the way, please don't SHOUT.

Hope this helps.

Pete