schedule

G

George A. Yorks

Have created a schedule with time slots,ie: 1;03 pm, 1:12
PM thru 6:25PM in 9 minute intervals. I am using the
following formula, =+c3+9/(24*60). I have inserted 1:03
PM in cell c3 and this formula in c4. I have dragged to
the last slot but the times come out as even hours. I am
doing something wrong but don't know what. Any help
appreciated
 
G

George A. Yorks

I have tried your suggested formula and it also does not
work. Any other suggestions??
 
F

Frank Kabel

Hi George
what does it mean 'does not work'. do you get an error, a wrong result,
etc?
 
G

George Yorks

I receive an error message that the formula contains an
error. Does not have a correction.
 
G

George Yorks

Hi,

I have tried using colon, semicolon and period and get
the same error message.

Any other ideas??

Thanks for your help
 
D

Dave Peterson

Just some followups.

#1. What's in C3? If you format that cell as General, what do you see in it?

#2. When you look at the column headers, do you see A, B, C...., IV or do
you see 1,2,3,...,256

If you see numbers, try Tools|options|General Tab
and uncheck R1C1 reference style

#3. Do you use an English version of excel? If no, what language do you use?
 
G

George Yorks

In answer to your question,
1. When formated in general the cell reads .54375

2. The column headers are A.b.c.....

3. I am using an English version of excel

Have one additional question. I have also tried to use
the following formula +c3+9/(24*60) and find that it works
properly some of the time but not all the time which is
very perplexing. Any thoughts
 
G

George Yorks

In answer to your question,
1. When formated in general the cell reads .54375

2. The column headers are A.b.c.....

3. I am using an English version of excel

Have one additional question. I have also tried to use
the following formula +c3+9/(24*60) and find that it works
properly some of the time but not all the time which is
very perplexing. Any thoughts
 
F

Frank Kabel

Hi
what does the formula
=ISNUMBER(C3)
return

For me it sounds like your number is actually stored as 'Text'
 
G

George Yorks

Good morning
=ISNUMBER(C3) comes back as TRUE
-----Original Message-----
Hi
what does the formula
=ISNUMBER(C3)
return

For me it sounds like your number is actually stored as 'Text'


--
Regards
Frank Kabel
Frankfurt, Germany




.
Click to expand...
 
F

Frank Kabel

Hi George
if you like email me your file wITH the formula you have used that
resulted in this error!

email: frank[dot]kabel[at]freenet[dot]de
 
D

Dave Peterson

Another couple of followups:

#1. When you say it (+c3+9/(24*60)) works properly sometimes, does that mean
you get an error or a result that you don't expect?

Maybe calculation is set for manual:
tools|options|calculation tab

And one more:
take a look at your windows regional settings:
windows start button|settings|control panel|regional settings applet
(is how I'd get to it in win98)

#2. On the Number tab, what's the List separator character?

That's the character that should be used where the comma is in this formula:

=C3+TIME(0,9,0)

(That was Frank's guess with the semicolon.)

#3. Have you defined a name in your workbook named Time or have you created a
userdefinedfunction (VBA code) that is named Time?

In xl2002, both of these didn't bother my formula, but I grasping a straws.

And the guesses get wilder....

#4. This formula: +c3+9/(24*60)
looks like you came from Lotus land. Any chance you have some options set for
lotus 123 under tools|options|Transition tab. (This, too, didn't bother xl2002
when I tested it.)

#5. I don't recall if you stated your version of excel. What version are you
running?

and something to try.

Start a new workbook. Put that value (.54375) in C3 and that formula that blows
up in d3. What happens?
 
Top