Groups | Search | Server Info | Login | Register

Groups > comp.sys.acorn.misc > #6284

Re: Eureka spreadsheet question.

Show all headers | View raw

In article <ant0304061cbBxcK@strongarm.half-baked-idea.co.uk>,
   Derek.Moody <derek.moody@casterbridge.net> wrote:

[Snippy]

> > 
> > Thanks. Unfortunately not much help. The Excel file was there for
> > those without Eureka to see the problem, my friend uses Eureka and the
> > [h]:mm is not accepted as a format.
> > 
> > Any other thoughts?

> Why are you recalculating every time rather than keeping a genuine
> running total?

I'm not doing anything, it's not my sheet nor my problem, I'm doing this
for a friend.
If it was my sheet I'd be quite happy for figures in the J column to be a
single decimal or double, I wouldn't care.

As a matter of interest, in the context of that sheet what would a genuine
running total be?

> Never mind; you are trying to treat a string as if it were a number.  Go
> back to general format and add to the end of your formula:

>   &IF(LEN(MINUTE(SUM($I$6:I6)))>1,"","0")

> Cheerio,

Thanks for that Derek, unfortunately it just produces an error message.

Maybe I'm putting it in the wrong place.

Dave

-- 

Dave Triffid

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