Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!feeder2.ecngs.de!ecngs!feeder.ecngs.de!Xl.tags.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!local2.nntp.ams.giganews.com!nntp.bt.com!news.bt.com.POSTED!not-for-mail NNTP-Posting-Date: Sat, 01 Sep 2012 17:43:24 -0500 From: spampling Subject: Re: Eureka spreadsheet question. Newsgroups: comp.sys.acorn.misc Date: Sat, 01 Sep 2012 22:05:27 +0100 Message-ID: <52c8908533spam.pling@btinternet.com> References: <52c87dce9fdave@triffid.co.uk> User-Agent: Pluto/2.05-a1 (RISC-OS/4.02) NewsHound/v1.50-32 Organization: Que? Orga-what Lines: 23 X-Usenet-Provider: http://www.giganews.com X-AuthenticatedUsername: NoAuthUser X-Trace: sv3-FT05KTTG5dNyw2z2Ti1ZxHgSmJjc5fpW4i18L7hn9EN8kqTZRUcQimAF4bB5RbEWvZRVnNTGjXYRa8a!rtM+tDsZHQgcZShEbDBgSRd2VvzCpUvPJKBn+SCTE3JQKx3YQPYJNbSzicdhtbUSHHjl X-Complaints-To: abuse@btinternet.com X-DMCA-Complaints-To: abuse@btinternet.com X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.40 X-Original-Bytes: 1856 Xref: csiph.com comp.sys.acorn.misc:6272 In article <52c87dce9fdave@triffid.co.uk>, Dave Symes wrote: > A friend has sent me a snippet of a Eureka spreadsheet, time sheet, and > asked a question I can't answer, so I'm wondering if anyone here can > cast some light. > The snippet of Eureka sheet is at > http://www.triffid.co.uk/dstuff/Eursheet.zip > The column J is a running time total, and if the time is say 4:25 then > it display as such, however if the time (As in J6) is an exact hour 4 it > will only display as 4:0 Also note J8 as 9:0 > His question was how do I get all the figures in the running total > column to be in the form of Hours and minutes to two places, so that J6 > will display as 4:00? I don't have eureka here but the answer to this kind of thing in spreadsheets is normally - set the decimal places to 2 -- Steve Pampling