schedule of classes

[kiloromeo]

hi friends,
need help in solving this problem..
i am working of scheduling classes for a school with instructors

problem is when i feed in time.. need a macro or a formula to give no of
periods. each pd is of 40 min.. so 0800-0840 1st period followed by 5 min break
0845 - 0925.. and so on
so once i type 0800 and 0925 in start and end column.. want to auto fill that it
is 2 pds and it is 1st and 2 nd..
thanks

[joe31623]

Please upload a sample worksheet of raw data on one worksheet and what you would want your results to be from that same raw data on the second worksheet.

It would also be helpful to clearly define where the complete raw data format will be. For example, are all times going to be entered in cell: "A1", Column: "A", row 1, etc.

[kiloromeo]

joe thanks for the reply.. attaching a worksheet with 3 sheets.. when i give the instr name in sheet one..
i want auto fill in sheet two..