Re: Eureka spreadsheet question.

Newsgroups	comp.sys.acorn.misc
Date	2012-09-03 00:07 +0100
From	"Derek.Moody" <derek.moody@casterbridge.net>
Subject	Re: Eureka spreadsheet question.
Message-ID	<ant0304061cbBxcK@strongarm.half-baked-idea.co.uk> (permalink)
Organization	Derek in Dorset U.K.
References	(3 earlier) <50431e66$0$289$14726298@news.sunsite.dk> <52c8e00831dave@triffid.co.uk> <52c8e1ae9ddave@triffid.co.uk> <50434c1f$0$283$14726298@news.sunsite.dk> <52c8eaeff4dave@triffid.co.uk>

Show all headers | View raw

In article <52c8eaeff4dave@triffid.co.uk>, Dave Symes
<URL:mailto:dave@triffid.co.uk> wrote:
> In article <50434c1f$0$283$14726298@news.sunsite.dk>,
>    Alex Macfarlane Smith <nospam@archifishal.co.uk> wrote:
> > In Excel, you can fix it by changing the format to [h]:mm (this permits 
> > hours longer than 24 hours).
> 
> > https://dl.dropbox.com/u/30539430/exceldocs/LargerX.xls
> 
> > Alex.
> 
> 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?

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,

-- 
>> derek.moody@casterbridge.net

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