Groups | Search | Server Info | Login | Register

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

Re: Eureka spreadsheet question.

Show all headers | View raw

On 2 Sep 2012, Dave Symes <dave@triffid.co.uk> wrote:
> > In article <52c87dce9fdave@triffid.co.uk>, Dave Symes
> > <dave@triffid.co.uk> wrote:

[snip]

> > > 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?

[snip]

>    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

Again, knowing nothing of Eureka, try changing the formula in column J
to 0:00 + <existing formula>. (In DataPower a similar arrangement can be
used to force a particular time display.)

Tony

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