Path: csiph.com!usenet.pasdenom.info!gegeweb.org!de-l.enfer-du-nord.net!feeder2.enfer-du-nord.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Dave Symes Newsgroups: comp.sys.acorn.misc Subject: Re: Eureka spreadsheet question. Date: Tue, 04 Sep 2012 18:48:24 +0100 Organization: Triffids Leg Press Lines: 24 Message-ID: <52ca09fca8dave@triffid.co.uk> References: <52c87dce9fdave@triffid.co.uk> <30b2f1c952.JohnyBoy@john.bryan86.fsnet.co.uk> X-Trace: individual.net 6vp60WCzEWEJk44255kqOQPRop434ePAM2u3WaI+AVS3DIdQcklPQYWNqL3R0KiEw/ X-Orig-Path: triffid.co.uk!dave Cancel-Lock: sha1:OOMNpcQCrpL8pY8YfwtqJJXKiDU= User-Agent: Pluto/3.04e (RISC-OS/6.20) NewsHound/v1.52-32 Xref: csiph.com comp.sys.acorn.misc:6331 In article <30b2f1c952.JohnyBoy@john.bryan86.fsnet.co.uk>, John Bryan wrote: [Snippy] > The simple answer is to format all the cells that have a time entered > into them using Menu> Format> Number and choose hh:mm from the list. > Any calculations done using this format including a running total stay > in the time format. > Mess Pro seems to think "hh:mm" is a HTML link there is no underline! > John Bryan I have to assume you've not seen the sample sheet. As I've said many times that does not work. The problem has been solved by Derek Moody, thanks again Derek. So I guess my friend is happy now. Dave -- Dave Triffid