Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.sys.acorn.misc > #6315
| From | Dave Symes <dave@triffid.co.uk> |
|---|---|
| Newsgroups | comp.sys.acorn.misc |
| Subject | Re: Eureka spreadsheet question. |
| Date | 2012-09-04 06:09 +0100 |
| Organization | Triffids Leg Press |
| Message-ID | <52c9c48173dave@triffid.co.uk> (permalink) |
| References | (6 earlier) <50434c1f$0$283$14726298@news.sunsite.dk> <52c8eaeff4dave@triffid.co.uk> <ant0304061cbBxcK@strongarm.half-baked-idea.co.uk> <52c941a952dave@triffid.co.uk> <ant0318260b0BxcK@strongarm.half-baked-idea.co.uk> |
In article <ant0318260b0BxcK@strongarm.half-baked-idea.co.uk>,
Derek.Moody <derek.moody@casterbridge.net> wrote:
> Your formula in J6:
> =(INT((SUM($I$6:I6)))*24)+(HOUR((SUM($I$6:I6))))&":"&MINUTE((SUM($I$6:I6)))
> becomes ('ware wrap):
> =(INT((SUM($I$6:I6)))*24)+(HOUR((SUM($I$6:I6))))&":"&MINUTE((SUM($I$6:I6)
> ))&IF(LEN(MINUTE(SUM($I$6:I6)))>1,"","0")
> and fill down.
> Cheerio,
Perfect.
Thanks Derek,
Friend will be very happy.
Dave
--
Dave Triffid
Back to comp.sys.acorn.misc | Previous | Next — Previous in thread | Next in thread | Find similar
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