Formula/programming in excel for cinema movie scheduling

[PREM SONI]

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

 

[Mike Fogleman]

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]

Hi Mike,

Thanks a lot for prompt reply!!!
Your formulas is good and will help me..but i want to take u in exact
situation. hope you could help me...

We are running a multiplex cinema where we have four auditorium i.e.
Audi-1
Audi-2
Audi-3
Audi-4

We need to create the movie schedule Audi wise like in Audi-1 movie A starts
at 10:00 Am and finished at 12:15 PM and next movie, Movie-C starts at 12:30
PM and finishes at its end time and so on....

Also we have to define interval time for each movie.

So pls let me know in detail how to set excel to create the movie schedule
Audi wise.

Thanks a lot for your help and support
PREM SONI

 

[Mike Fogleman]

Why can't you use my suggestion for each of the 4 audis? Audi2 would start
with movie B, audi 3 starts with movie C, etc. You haven't given me enough
information to help you with. Also, what is your definition of Interval time
per movie? What exactly do you want the schedule to do and what would it
look like when it is done. What variables are there to deal with - for
example: do all 4 audis start at 10:00 AM, how many different movies are ran
per day, is 1 movie ran exclusively in 1 audi or are they mixed, do you want
to choreograph or stagger the end/start times of the 4 audis so that ticket
and concession are not overwhelmed. In order to provide more precise
solutions, I need more precise details.
Thanks,
Mike IF