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?
.
|