If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Movie Times Calculation?
I work for a major theatre chain an no one (inclduing the help desk) can figure
out how to make a show start/end time schedule calculate the ending time. For example A3 would list the lenght of the show in minute, A4 (5,6, and so on) would list the start time(s). We want B4 (5,6, etc) to list the end time. We have a formula now but it won't work with shows that jump over 12 noon or 12 midnight without manually going into the formula and adding or subtracting 12. Can anyone help or direct me to a solution source? |
#2
|
|||
|
|||
Movie Times Calculation?
"CAMooV" wrote in message
... I work for a major theatre chain an no one (inclduing the help desk) can figure out how to make a show start/end time schedule calculate the ending time. For example A3 would list the lenght of the show in minute, A4 (5,6, and so on) would list the start time(s). We want B4 (5,6, etc) to list the end time. We have a formula now but it won't work with shows that jump over 12 noon or 12 midnight without manually going into the formula and adding or subtracting 12. Can anyone help or direct me to a solution source? Always paste the formula you are using! It's so much easier to see what might be wrong. I'm assuming the times are entered as times, such as 11:30 AM or 22:45 . If A3 is a time value (so 65 minutes would be 1:05), the formula for B4 would just be =A4+$A$3 If A3 is a simple number (65 minutes is just 65), the formula for B4 would be =A4+$A$3/1440 as times are stored as fractions of a day and there are 1440 minutes in a day. If this doesn't help you to solve it, post your formula and tell us how the cells (just concentrate on A3, A4 and B4) are formatted. |
#3
|
|||
|
|||
Movie Times Calculation?
CAM,
All you need in B4 is =A4 +A$3/24/60 and make sure that B4, etc is formatted as time. -- HTH Bob Phillips "CAMooV" wrote in message ... I work for a major theatre chain an no one (inclduing the help desk) can figure out how to make a show start/end time schedule calculate the ending time. For example A3 would list the lenght of the show in minute, A4 (5,6, and so on) would list the start time(s). We want B4 (5,6, etc) to list the end time. We have a formula now but it won't work with shows that jump over 12 noon or 12 midnight without manually going into the formula and adding or subtracting 12. Can anyone help or direct me to a solution source? |
#4
|
|||
|
|||
Movie Times Calculation?
I have a simple solution that works, but is not very
elegant. Format cell A3 with Time and 13:30 (second down on the pick-list). Format the other cells with Time and 1:30pm (third down on list). Enter start times in 24 hour time: 11:30am is 11:30, 1:00pm is 13:00, and 5:30pm is 17:30 (i.e., add 12 hours to pm times). Note the times should display in AM and PM. Enter run times in hours and minutes: 93 minutes is 1:33. Create the formula in B4 of A4+A3. This setup in B4 will cycle past noon and midnight to give the correct time and display it in AM and PM. -----Original Message----- I work for a major theatre chain an no one (inclduing the help desk) can figure out how to make a show start/end time schedule calculate the ending time. For example A3 would list the lenght of the show in minute, A4 (5,6, and so on) would list the start time(s). We want B4 (5,6, etc) to list the end time. We have a formula now but it won't work with shows that jump over 12 noon or 12 midnight without manually going into the formula and adding or subtracting 12. Can anyone help or direct me to a solution source? . |
Thread Tools | |
Display Modes | |
|
|