A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Movie Times Calculation?



 
 
Thread Tools Display Modes
  #1  
Old September 18th, 2003, 04:09 PM
CAMooV
external usenet poster
 
Posts: n/a
Default 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  
Old September 18th, 2003, 04:33 PM
Anon
external usenet poster
 
Posts: n/a
Default 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  
Old September 18th, 2003, 04:41 PM
Bob Phillips
external usenet poster
 
Posts: n/a
Default 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  
Old September 18th, 2003, 05:08 PM
Charlie
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:16 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.