Assume movie lengths in column B, starting in row 2. Column C will be start
time & D will be end time. Format the cells in C & D you will need, as Time
(1:30 PM for example). In cell C2 enter the time you want to start the 1st
movie like this 10:00. in cell D2 put the formula: =C2+(B2/1440).
Drag/filldown the formula to the last movie row. Now in cell C3 put the
formula: =D2+(15/1440) and drag/filldown to the last movie row.

The formula =C2+(B2/1440) takes the start time and adds the movie length to
it. Since the movie length is measured in minutes, we divide the length by
1440, which is the number of minutes in a day. This will find what decimal
part of a day 120 minutes is, so we can add that to the start time.

The formula =D2+(15/1440) calculates the start time of the next movie by
adding 15 minutes to the end time of the previous movie, using the same
divide by 1440 method.

Mike F

"PREM SONI" wrote in message
...
Hi All,

I want the formula/programming in excel for cinema movie scheduling...

i.e. i have 4 Movies as given below:

Movie A's length is 120 minutes
Movie B's length is 104 minutes
Movie C's length is 90 minutes
Movie D's length is 135 minutes

Now i want to define all above movie in excel and starts movie A at 10:30
AM and it will be over at 12:30 PM and then i starts second movie B at
12:45
PM and it will be finish at 2:29 PM.

I want all this in excel...kindly suggest is it possible if yes how can i
do
it?
Hope i am able to make you understand what i wants...

Thanks
PREM SONI