Got crazy trying this.. Please Help !!!

[nianchi111]

Dear Friends,

Shift Time is from 8:30 to 17:00

I have Two timings Column A Start time Column B End time.

Start Time End Time

17/Feb/11 17:22 25/Feb/11 7:16
17/Feb/11 17:22 22/Feb/11 8:50
21/Feb/11 17:03 22/Feb/11 8:50
21/Feb/11 18:07 22/Feb/11 7:46

Criteria:

For example:
Start Time End Time

17/Feb/11 17:22 25/Feb/11 7:16
the start time should be the next working day as the shift ends at 17 hours

25/Feb/11 7:16 - 18/Feb/11 8:30

Network days is 5

So the calculation should be (5 * 8:30) so the total time is 42:30:00

If the End time is greater that 8:30 then we have to add the difference to 42:30:00

Thanks,
Nianchi111.