does not work in XL97 (or that it's a bit old so we're not bothered
anyway...)

yer, I always knew I was the poor cousin <g

--

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Pete_UK" wrote in message
oups.com...
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

Sandy Mann wrote:
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


with @tiscali.co.uk


"Sandy Mann" wrote in message
...
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


with @tiscali.co.uk


"daddylonglegs"
wrote in
message
news:daddylonglegs.2bzh0j_1154640959.0549@excelfor um-nospam.com...

Hi Sandy,

You're right, you really need to input the times manually, see here

http://support.microsoft.com/kb/211830/en-us


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=567674