Groups | Search | Server Info | Login | Register

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

Eureka spreadsheet question.

Show all headers | View raw

In article <50431e66$0$289$14726298@news.sunsite.dk>,
   Alex Macfarlane Smith <nospam@archifishal.co.uk> wrote:
> On 02/09/2012 06:35, Dave Symes wrote:
> [snippity]
> >
> > There is now also, an Excel version of the Snippet inside the archive at
> > the address given yesterday, and FWIW I can't sort it in Excel either.
> >
> > Thanks
> > Dave
> >
> >     A     B       C        D  ....      I        J
> > -----------------------------------------------------------
> >                                       Net Time  Running
> >
> > 6|     Date     8:15    12:15        4:00       4:0
> >
> > 7|     Date     9:10    11:25        2:15      6.15
> >
> > 8|     Date     9:30    12:15        2:45       9:0
> >
> > The formatting is identical for the whole of column J in the form of
> > h:mm Changing it to h:mmmm or 0.00 nor even 0:00
> >
> > I guess something in the formula needs modifying so that if the hour
> > is a full hour with no minute increments it displays as  h:00
> >
> > My brains is pudding from messing with this...
> >
> > D.
> >

> If you want to do what I think you want to do, then this seems to work:

> https://dl.dropbox.com/u/30539430/ExcelFile.xls

> J6  =(SUM($I$6:I6))
> J7  =(SUM($I$6:I7))
> J8  =(SUM($I$6:I8))

> I think the problem with what you were trying was that you were 
> effectively creating a string (by adding the ':' in the middle), so the 
> formatting you had on the cell had no effect.

> Alex.

Thanks for that Alex,
In theory your solution would work, but for some reason I can't fathom it
is not producing the correct totals.

I'm going to contact the friend (Sheet owner) and ask if its' okay for me
to put up a bigger sample of the actual sheet.

Thanks
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