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