Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula/programming in excel for cinema movie scheduling
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula/programming in excel for cinema movie scheduling
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula/programming in excel for cinema movie scheduling
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" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula/programming in excel for cinema movie scheduling
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 "PREM SONI" wrote in message ... 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" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for scheduling in advance | Excel Discussion (Misc queries) | |||
Can't figure out formula- scheduling | Excel Discussion (Misc queries) | |||
AWESOME MOVIE! << I found this movie link in an AOL chatroom. It is based on real evidence and I give it a big thumbs-up. | Excel Programming | |||
Linking a Movie File to Excel | Excel Programming |