schedule

[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

 

[Frank Kabel]

Hi
try
=C3+TIME(0,9,0)

 

[George A. Yorks]

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

 

[Llobid]

Try formatting the cell with your formula as 1:30 PM

 

[Frank Kabel]

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

 

[George Yorks]

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

 

[Frank Kabel]

Hi
are you using the semicolon as delimiter?. If yes try
=C3+TIME(0;9;0)

 

[George Yorks]

Hi,

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

Any other ideas??

Thanks for your help

 

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

 

[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

 

[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

 

[Frank Kabel]

Hi
what does the formula
=ISNUMBER(C3)
return

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

 

[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




.

 

[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

 

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