Mr

please can you help,

I need a schedule that reflects a row at half hour (30 minutes) intervals and working-days only, for a period of three weeks. ie 48 columns per day. The first cell is outomaticaly retreafed from worksheet 1 and this first row of 48 columns is on worksheet 2.

formula in cell A1 is =INPUT!I27 and formula in cell B1 is =IF(WEEKDAY(F38,2) + 1 >5, F38+(7-WEEKDAY(F38,2)) + 1,G45F38 + 1) this formula in B1 must pls run at half-hour intervals.

thanking you in advance

 

Willem

By: Willem Mol

Leave a Reply

Your email address will not be published. Required fields are marked *