Re: Eureka spreadsheet question.

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 <spam.pling@btinternet.com>
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> (permalink)
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

Show key headers only | View raw

In article <52c87dce9fdave@triffid.co.uk>, Dave Symes <dave@triffid.co.uk>
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

Back to comp.sys.acorn.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-09-01 18:41 +0100
  Re: Eureka spreadsheet question. spampling <spam.pling@btinternet.com> - 2012-09-01 22:05 +0100
    Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-09-02 06:35 +0100
      Re: Eureka spreadsheet question. Alex Macfarlane Smith <nospam@archifishal.co.uk> - 2012-09-02 09:52 +0100
        Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-09-02 12:33 +0100
          Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-09-02 12:51 +0100
            Re: Eureka spreadsheet question. Alex Macfarlane Smith <nospam@archifishal.co.uk> - 2012-09-02 13:07 +0100
              Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-09-02 14:33 +0100
                Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-09-02 18:36 +0100
                Re: Eureka spreadsheet question. "Derek.Moody" <derek.moody@casterbridge.net> - 2012-09-03 00:07 +0100
                Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-09-03 06:20 +0100
                Re: Eureka spreadsheet question. Chris Evans <chris@cjemicros.co.uk> - 2012-09-03 13:06 +0100
                Re: Eureka spreadsheet question. "Derek.Moody" <derek.moody@casterbridge.net> - 2012-09-03 19:02 +0100
                Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-09-04 06:09 +0100
      Re: Eureka spreadsheet question. Tony Moore <old_coaster@yahoo.co.uk> - 2012-09-02 11:36 +0000
  Re: Eureka spreadsheet question. John Bryan <john@bryan86.fsnet.co.uk> - 2012-09-04 14:23 +0100
    Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-09-04 18:48 +0100
      Re: Eureka spreadsheet question. "Derek.Moody" <derek.moody@casterbridge.net> - 2012-09-06 00:21 +0100

csiph-web