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

On Oct 19, 8:41 pm, "WILSONLA001" <u38391@uwe wrote:
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);_(* "-"??_);_(@_)