calculate class Periods Time: Stuck

Respectable Greeting to all

1. I want auto calculate class Periods Time from "1st period to last period".
when enter Starting time of 1st period and it calculate all give period in sheet automatically from 1st to last Period Automatically each of 40min

2. Break "Junior Break" and "Senior Break" is change which you can see in attach excel Sheet which is 15min

3. Friday time is Short of each period of 30min and break is 10min

Plz see the Attach Excel sheet
class period time.xlsx


Plz see the Image of Excel sheet
class period time.jpg

i am wondering is it possible through Formula or any idea will be highly appreciated.

High Regards

Originally Posted by bebo021999

Is this are you looking for?

Superbly Done and Solved, with simple Formula which i was not able to figure it out. you Solved it like a piece of Chocolate Cake

Thanks a lot.. it is Highly Appreciated

Best Regards

Thread marked as solved and reputation ADD

my apologies that my post does not comply with Rule 8 of our Forum RULES, i be careful next, thanks for guiding

Originally Posted by windy58

A variation on bebo021999's formula

=D13+TIME(0,40,0)

Just change the 40 for required period or use a cell reference and named ranges this would make it easier to change in the future.

Windy

Beautifully Solved .... thanks .. it is Highly Appreciated

Best Regards

Thread marked as solved and reputation ADD