Between time

B

Brento

HI,

If any one could help with this i would be greatful.

I have thetime time in a1 starting at 08:00 and going down the pagein
15 mintue intervals, in the next column i have a number next to the
time.

I would like a formula to be able to read and display the second column
number depending on the time stated in cell c1 in d1.

any help would be great.

thanks
brent
 
S

Sandy Mann

I don't know if this is a problem with my XL97 but if I enter the times by
either entering 08:00 in A1 and 08:15 in A2, highlighting them both and
dragging down or use the formula: = A1+TIME(0,15,0), then Daddylonglegs
excelent formula returns the number *before* the required one. If the times
are entered directly then the formula returns the correct result so it is a
problem with the indexing not the formula.

--

Sandy
In Perth, the ancient capital of Scotland

[email protected]
[email protected] with @tiscali.co.uk
 
S

Sandy Mann

Thank you Daddylonglegs,

I tried precision as displayed as the article suggests but it failed to
correct the problem for me whether applied before or after the data/formula.

It's not very elegant but I found that:

=CEILING(A1+TIME(0,15,0),TIME(0,15,0))

seemed to correct the problem then of course you could copy/paste special >
values

Just thinking about creating a large number of progressive usable times

--

Sandy
In Perth, the ancient capital of Scotland

[email protected]
[email protected] with @tiscali.co.uk


"daddylonglegs" <[email protected]>
wrote in message
news:[email protected]...
 
S

Sandy Mann

For the archives, if for no other reason, I tried the *precision as
displayed* on XL 2002 at work and it corrected the return form the function.
(But then you all new that would didn't you <g>)

However, there are many times when you would not want to have that option
selected.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland

[email protected]
[email protected] with @tiscali.co.uk
 
P

Pete_UK

Sandy,

the Microsoft article did not refer to XL97. One could take that to
mean that it is not affected by this "feature", or that the correction
does not work in XL97 (or that it's a bit old so we're not bothered
anyway...)

Pete
 
Top