Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

I've got a COUSIN who works in the GARMENT DISTRICT ...


aus+uk / uk.comp.sys.mac / Re: ISO 8601 timestamps and Numbers

SubjectAuthor
* ISO 8601 timestamps and NumbersIan McCall
+* ISO 8601 timestamps and NumbersGraeme Wall
|`- ISO 8601 timestamps and NumbersIan McCall
+* ISO 8601 timestamps and NumbersChris Ridd
|`* ISO 8601 timestamps and NumbersIan McCall
| `* ISO 8601 timestamps and NumbersChris Ridd
|  `- ISO 8601 timestamps and NumbersGraeme Wall
`* ISO 8601 timestamps and NumbersRichard Tobin
 +- ISO 8601 timestamps and NumbersIan McCall
 `* ISO 8601 timestamps and NumbersChris Ridd
  `* ISO 8601 timestamps and NumbersGraeme Wall
   `* ISO 8601 timestamps and NumbersChris Ridd
    `- ISO 8601 timestamps and NumbersGraeme Wall

1
ISO 8601 timestamps and Numbers

<0001HW.2821A7B50556C38B70000879F38F@news.individual.net>

 copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=8343&group=uk.comp.sys.mac#8343

 copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!news.szaf.org!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: ian...@eruvia.org (Ian McCall)
Newsgroups: uk.comp.sys.mac
Subject: ISO 8601 timestamps and Numbers
Date: Tue, 03 May 2022 19:11:01 +0100
Lines: 10
Message-ID: <0001HW.2821A7B50556C38B70000879F38F@news.individual.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
X-Trace: individual.net zcHdTOS2UbS+dULipRyh8Qh5pmQndjn3ihes8gHTGzxca7asiS
X-Orig-Path: not-for-mail
Cancel-Lock: sha1:5hwY5A4H92XhlsIArJ+3m2mgrg8=
User-Agent: Hogwasher/5.24
 by: Ian McCall - Tue, 3 May 2022 18:11 UTC

Seems Numbers doesn’t understand them. I have a column full of entries like
“2021-05-01T05:30:00+01:00”, I set the Cell Data Type to "Date&
Time”...nothing. It doesn’t recognise these values as dates at all.

Any way around this? Must say does feel like quite an oversight.

Thanks,
Ian

Re: ISO 8601 timestamps and Numbers

<t4s4kr$e0l$3@dont-email.me>

 copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=8344&group=uk.comp.sys.mac#8344

 copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: rai...@greywall.demon.co.uk (Graeme Wall)
Newsgroups: uk.comp.sys.mac
Subject: Re: ISO 8601 timestamps and Numbers
Date: Tue, 3 May 2022 21:51:39 +0100
Organization: A noiseless patient Spider
Lines: 16
Message-ID: <t4s4kr$e0l$3@dont-email.me>
References: <0001HW.2821A7B50556C38B70000879F38F@news.individual.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Tue, 3 May 2022 20:51:39 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="0bd279dcf68c3796a2bee5d452ac37ee";
logging-data="14357"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+SjmMS5n7YSCPaFRFAkIPmRVjoeXuc22I="
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0)
Gecko/20100101 Thunderbird/91.8.1
Cancel-Lock: sha1:dZXAGq2ZRhYfRT9pqduAJ018rVg=
In-Reply-To: <0001HW.2821A7B50556C38B70000879F38F@news.individual.net>
Content-Language: en-GB
 by: Graeme Wall - Tue, 3 May 2022 20:51 UTC

On 03/05/2022 19:11, Ian McCall wrote:
> Seems Numbers doesn’t understand them. I have a column full of entries like
> “2021-05-01T05:30:00+01:00”, I set the Cell Data Type to "Date&
> Time”...nothing. It doesn’t recognise these values as dates at all.
>
> Any way around this? Must say does feel like quite an oversight.
>

replacing the T with a space helps but I can't get it to recognise the
+01:00

NB you did set the Date and Time formats?
--
Graeme Wall
This account not read.

Re: ISO 8601 timestamps and Numbers

<t4sv14$mp9$1@dont-email.me>

 copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=8345&group=uk.comp.sys.mac#8345

 copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: chrisr...@mac.com (Chris Ridd)
Newsgroups: uk.comp.sys.mac
Subject: Re: ISO 8601 timestamps and Numbers
Date: Wed, 4 May 2022 05:21:55 +0100
Organization: A noiseless patient Spider
Lines: 18
Message-ID: <t4sv14$mp9$1@dont-email.me>
References: <0001HW.2821A7B50556C38B70000879F38F@news.individual.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Wed, 4 May 2022 04:21:56 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="1b958f12e52e17e10ce216e079a2d095";
logging-data="23337"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18QGeIyIAlUJq/k88+UkaQyz1wWrXfq6S8="
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0)
Gecko/20100101 Thunderbird/91.8.1
Cancel-Lock: sha1:m63nTnIvOcmt0I0kVxpqIqFERJE=
In-Reply-To: <0001HW.2821A7B50556C38B70000879F38F@news.individual.net>
 by: Chris Ridd - Wed, 4 May 2022 04:21 UTC

On 03/05/2022 19:11, Ian McCall wrote:
> Seems Numbers doesn’t understand them. I have a column full of entries like
> “2021-05-01T05:30:00+01:00”, I set the Cell Data Type to "Date&
> Time”...nothing. It doesn’t recognise these values as dates at all.
>
> Any way around this? Must say does feel like quite an oversight.

Set a custom date and time format inside Numbers. Works here, except
there's no option for timezone offsets.

I suspect the latter means that internally all dates and times are
considered local. It looks a bit like Excel has the same limitation.

Arguably Numbers should understand more standard date and time formats,
but there'll always be one more standard out there it does not...

--
Chris

Re: ISO 8601 timestamps and Numbers

<0001HW.2822B0F70575F45670000879F38F@news.individual.net>

 copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=8346&group=uk.comp.sys.mac#8346

 copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!news.szaf.org!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: ian...@eruvia.org (Ian McCall)
Newsgroups: uk.comp.sys.mac
Subject: Re: ISO 8601 timestamps and Numbers
Date: Wed, 04 May 2022 14:02:47 +0100
Lines: 15
Message-ID: <0001HW.2822B0F70575F45670000879F38F@news.individual.net>
References: <0001HW.2821A7B50556C38B70000879F38F@news.individual.net> <t4s4kr$e0l$3@dont-email.me>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
X-Trace: individual.net A9D7EZSyXPtyY1l5TpblDQYT5yAnt9VuGtblhr9dNGuffQRpwA
X-Orig-Path: not-for-mail
Cancel-Lock: sha1:aGvIPkYlTibz/z7QJAzw/XLXgV4=
User-Agent: Hogwasher/5.24
 by: Ian McCall - Wed, 4 May 2022 13:02 UTC

On 3 May 2022, Graeme Wall wrote
(in article <t4s4kr$e0l$3@dont-email.me>):

> replacing the T with a space helps but I can't get it to recognise the
> +01:00
>
> NB you did set the Date and Time formats?

Not sure how to do that to be honest. I have found “custom format”, but I
can’t make one match ISO8601.

Cheers,
Ian

Re: ISO 8601 timestamps and Numbers

<0001HW.2822B187057615F470000879F38F@news.individual.net>

 copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=8347&group=uk.comp.sys.mac#8347

 copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!news.szaf.org!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: ian...@eruvia.org (Ian McCall)
Newsgroups: uk.comp.sys.mac
Subject: Re: ISO 8601 timestamps and Numbers
Date: Wed, 04 May 2022 14:05:11 +0100
Lines: 27
Message-ID: <0001HW.2822B187057615F470000879F38F@news.individual.net>
References: <0001HW.2821A7B50556C38B70000879F38F@news.individual.net> <t4sv14$mp9$1@dont-email.me>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
X-Trace: individual.net sIZrVTccK6qVwpfbQZLitwX3EAaqe120PDvv0R9LjY25WVwvST
X-Orig-Path: not-for-mail
Cancel-Lock: sha1:kVRiG+v3jLamqPzCaNt2plHfpYE=
User-Agent: Hogwasher/5.24
 by: Ian McCall - Wed, 4 May 2022 13:05 UTC

On 4 May 2022, Chris Ridd wrote
(in article <t4sv14$mp9$1@dont-email.me>):

> On 03/05/2022 19:11, Ian McCall wrote:
> > Seems Numbers doesn’t understand them. I have a column full of entries
> > like
> > “2021-05-01T05:30:00+01:00”, I set the Cell Data Type to "Date&
> > Time”...nothing. It doesn’t recognise these values as dates at all.
> >
> > Any way around this? Must say does feel like quite an oversight.
>
> Set a custom date and time format inside Numbers. Works here, except
> there's no option for timezone offsets.

Yep - exactly. I can’t get it working (including the T bit, as well as the
offset)

> Arguably Numbers should understand more standard date and time formats,
> but there'll always be one more standard out there it does not...

Agreed, but ISO 8601 of all things. You would really, -really- expect that
one to be recognised.

Cheers,
Ian

Re: ISO 8601 timestamps and Numbers

<t4u16v$a8n$1@macpro.inf.ed.ac.uk>

 copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=8348&group=uk.comp.sys.mac#8348

 copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!aioe.org!nntp.terraraq.uk!nntp-feed.chiark.greenend.org.uk!ewrotcd!usenet.inf.ed.ac.uk!.POSTED!not-for-mail
From: rich...@cogsci.ed.ac.uk (Richard Tobin)
Newsgroups: uk.comp.sys.mac
Subject: Re: ISO 8601 timestamps and Numbers
Date: Wed, 4 May 2022 14:05:19 +0000 (UTC)
Organization: Language Technology Group, University of Edinburgh
Lines: 17
Message-ID: <t4u16v$a8n$1@macpro.inf.ed.ac.uk>
References: <0001HW.2821A7B50556C38B70000879F38F@news.individual.net>
NNTP-Posting-Host: macaroni.inf.ed.ac.uk
X-Trace: macpro.inf.ed.ac.uk 1651673119 10519 129.215.197.42 (4 May 2022 14:05:19 GMT)
X-Complaints-To: usenet@macpro.inf.ed.ac.uk
NNTP-Posting-Date: Wed, 4 May 2022 14:05:19 +0000 (UTC)
X-Newsreader: trn 4.0-test76 (Apr 2, 2001)
Originator: richard@cogsci.ed.ac.uk (Richard Tobin)
 by: Richard Tobin - Wed, 4 May 2022 14:05 UTC

In article <0001HW.2821A7B50556C38B70000879F38F@news.individual.net>,
Ian McCall <ian@eruvia.org> wrote:

>Seems Numbers doesn’t understand them. I have a column full of entries like
>“2021-05-01T05:30:00+01:00”, I set the Cell Data Type to "Date&
>Time”...nothing. It doesn’t recognise these values as dates at all.
>
>Any way around this? Must say does feel like quite an oversight.

I know nothing about Numbers, but wouldn't a spreadsheety way to
handle it be to have another column with a formula that rearranges the
bits of the original into a date format it understands?

Presumably there's something that lets you add some hours to a date
to handle the timezone.

-- Richard

Re: ISO 8601 timestamps and Numbers

<0001HW.2822C63A057AEFDD70000879F38F@news.individual.net>

 copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=8349&group=uk.comp.sys.mac#8349

 copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!news.neodome.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: ian...@eruvia.org (Ian McCall)
Newsgroups: uk.comp.sys.mac
Subject: Re: ISO 8601 timestamps and Numbers
Date: Wed, 04 May 2022 15:33:30 +0100
Lines: 14
Message-ID: <0001HW.2822C63A057AEFDD70000879F38F@news.individual.net>
References: <0001HW.2821A7B50556C38B70000879F38F@news.individual.net> <t4u16v$a8n$1@macpro.inf.ed.ac.uk>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
X-Trace: individual.net dMq9W3x5HJA6/3nv3AzUBwpcvyS52AwBxyfwiSPU8z8LIgNJ/z
X-Orig-Path: not-for-mail
Cancel-Lock: sha1:hz5rxWhwVbbE4pGzLiOVaTB3oYI=
User-Agent: Hogwasher/5.24
 by: Ian McCall - Wed, 4 May 2022 14:33 UTC

On 4 May 2022, Richard Tobin wrote
(in article <t4u16v$a8n$1@macpro.inf.ed.ac.uk>):

> I know nothing about Numbers, but wouldn't a spreadsheety way to
> handle it be to have another column with a formula that rearranges the
> bits of the original into a date format it understands?

That would work - some playing around with substrings I guess. Thanks for
that.

Cheers,
Ian

Re: ISO 8601 timestamps and Numbers

<t4uabf$oud$1@dont-email.me>

 copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=8350&group=uk.comp.sys.mac#8350

 copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: chrisr...@mac.com (Chris Ridd)
Newsgroups: uk.comp.sys.mac
Subject: Re: ISO 8601 timestamps and Numbers
Date: Wed, 4 May 2022 17:41:18 +0100
Organization: A noiseless patient Spider
Lines: 42
Message-ID: <t4uabf$oud$1@dont-email.me>
References: <0001HW.2821A7B50556C38B70000879F38F@news.individual.net>
<t4sv14$mp9$1@dont-email.me>
<0001HW.2822B187057615F470000879F38F@news.individual.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Wed, 4 May 2022 16:41:19 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="1b958f12e52e17e10ce216e079a2d095";
logging-data="25549"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18Cqdju9m2yIQbfL8Q+XgZpW57vr7RD98Q="
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0)
Gecko/20100101 Thunderbird/91.8.1
Cancel-Lock: sha1:MCUIuJVKTeIXiLNX4gY6+A7D5mE=
In-Reply-To: <0001HW.2822B187057615F470000879F38F@news.individual.net>
 by: Chris Ridd - Wed, 4 May 2022 16:41 UTC

On 04/05/2022 14:05, Ian McCall wrote:
> On 4 May 2022, Chris Ridd wrote
> (in article <t4sv14$mp9$1@dont-email.me>):
>
>> On 03/05/2022 19:11, Ian McCall wrote:
>>> Seems Numbers doesn’t understand them. I have a column full of entries
>>> like
>>> “2021-05-01T05:30:00+01:00”, I set the Cell Data Type to "Date&
>>> Time”...nothing. It doesn’t recognise these values as dates at all.
>>>
>>> Any way around this? Must say does feel like quite an oversight.
>>
>> Set a custom date and time format inside Numbers. Works here, except
>> there's no option for timezone offsets.
>
> Yep - exactly. I can’t get it working (including the T bit, as well as the
> offset)

Well ignoring the offset part because apparently spreadsheets don't do
timezones without something like Richard's suggestion, you'd do this:

Inspector Cell tab
Data Format: Create Custom Format
(new dialog appears)
Name: ISO 8601 there or thereabouts
Type: Date & Time
Custom Format: [Year]-[Month]-[Day of Month]T[Hour]:[Minute]:[Second]

Each [label] has a popup letting you choose, say, 00-23 for the hour.

>
>> Arguably Numbers should understand more standard date and time formats,
>> but there'll always be one more standard out there it does not...
>
> Agreed, but ISO 8601 of all things. You would really, -really- expect that
> one to be recognised.

Yes, as a European I'd agree with you. But there are other genuine
standards they also don't do.

--
Chris

Re: ISO 8601 timestamps and Numbers

<t4uds3$na0$1@dont-email.me>

 copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=8351&group=uk.comp.sys.mac#8351

 copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: rai...@greywall.demon.co.uk (Graeme Wall)
Newsgroups: uk.comp.sys.mac
Subject: Re: ISO 8601 timestamps and Numbers
Date: Wed, 4 May 2022 18:41:23 +0100
Organization: A noiseless patient Spider
Lines: 39
Message-ID: <t4uds3$na0$1@dont-email.me>
References: <0001HW.2821A7B50556C38B70000879F38F@news.individual.net>
<t4sv14$mp9$1@dont-email.me>
<0001HW.2822B187057615F470000879F38F@news.individual.net>
<t4uabf$oud$1@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Wed, 4 May 2022 17:41:23 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="a792d7d355fe5e4dd61a8bbedbfdbe2a";
logging-data="23872"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19K3OdIgwxcQ8zWeqD1FJpj5AuRPk3LADI="
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0)
Gecko/20100101 Thunderbird/91.8.1
Cancel-Lock: sha1:d+i+e/CqOuiQF2KJAub+ZUx2ke4=
In-Reply-To: <t4uabf$oud$1@dont-email.me>
Content-Language: en-GB
 by: Graeme Wall - Wed, 4 May 2022 17:41 UTC

On 04/05/2022 17:41, Chris Ridd wrote:
> On 04/05/2022 14:05, Ian McCall wrote:
>> On 4 May 2022, Chris Ridd wrote
>> (in article <t4sv14$mp9$1@dont-email.me>):
>>
>>> On 03/05/2022 19:11, Ian McCall wrote:
>>>> Seems Numbers doesn’t understand them. I have a column full of entries
>>>> like
>>>> “2021-05-01T05:30:00+01:00”, I set the Cell Data Type to "Date&
>>>> Time”...nothing. It doesn’t recognise these values as dates at all.
>>>>
>>>> Any way around this? Must say does feel like quite an oversight.
>>>
>>> Set a custom date and time format inside Numbers. Works here, except
>>> there's no option for timezone offsets.
>>
>> Yep - exactly. I can’t get it working (including the T bit, as well as
>> the
>> offset)
>
> Well ignoring the offset part because apparently spreadsheets don't do
> timezones without something like Richard's suggestion, you'd do this:
>
> Inspector Cell tab
> Data Format: Create Custom Format
> (new dialog appears)
> Name: ISO 8601 there or thereabouts
> Type: Date & Time
> Custom Format: [Year]-[Month]-[Day of Month]T[Hour]:[Minute]:[Second]
>
> Each [label] has a popup letting you choose, say, 00-23 for the hour.
>

Neat

--
Graeme Wall
This account not read.

Re: ISO 8601 timestamps and Numbers

<t4ugsa$kl8$1@dont-email.me>

 copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=8352&group=uk.comp.sys.mac#8352

 copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: chrisr...@mac.com (Chris Ridd)
Newsgroups: uk.comp.sys.mac
Subject: Re: ISO 8601 timestamps and Numbers
Date: Wed, 4 May 2022 19:32:41 +0100
Organization: A noiseless patient Spider
Lines: 9
Message-ID: <t4ugsa$kl8$1@dont-email.me>
References: <0001HW.2821A7B50556C38B70000879F38F@news.individual.net>
<t4u16v$a8n$1@macpro.inf.ed.ac.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Wed, 4 May 2022 18:32:42 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="1b958f12e52e17e10ce216e079a2d095";
logging-data="21160"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19BZXKo74Mq6PuNtbA49ZYG47mwAB4RpZk="
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0)
Gecko/20100101 Thunderbird/91.8.1
Cancel-Lock: sha1:0YskydBIOuU1UWBQLHo25TPmHgU=
In-Reply-To: <t4u16v$a8n$1@macpro.inf.ed.ac.uk>
 by: Chris Ridd - Wed, 4 May 2022 18:32 UTC

On 04/05/2022 15:05, Richard Tobin wrote:
> Presumably there's something that lets you add some hours to a date
> to handle the timezone.

Yes, plain old arithmetic. Add (1/24) to a date/time value to increase
it by one hour.

--
Chris

Re: ISO 8601 timestamps and Numbers

<t4uon2$4f0$3@dont-email.me>

 copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=8353&group=uk.comp.sys.mac#8353

 copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: rai...@greywall.demon.co.uk (Graeme Wall)
Newsgroups: uk.comp.sys.mac
Subject: Re: ISO 8601 timestamps and Numbers
Date: Wed, 4 May 2022 21:46:26 +0100
Organization: A noiseless patient Spider
Lines: 15
Message-ID: <t4uon2$4f0$3@dont-email.me>
References: <0001HW.2821A7B50556C38B70000879F38F@news.individual.net>
<t4u16v$a8n$1@macpro.inf.ed.ac.uk> <t4ugsa$kl8$1@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Wed, 4 May 2022 20:46:26 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="a792d7d355fe5e4dd61a8bbedbfdbe2a";
logging-data="4576"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19oMsr5zbu6MYu/FxkZwJzbEbMCmk7lReU="
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0)
Gecko/20100101 Thunderbird/91.8.1
Cancel-Lock: sha1:mWFPLZV69vHt6EfZNQhvSGh8v/M=
In-Reply-To: <t4ugsa$kl8$1@dont-email.me>
Content-Language: en-GB
 by: Graeme Wall - Wed, 4 May 2022 20:46 UTC

On 04/05/2022 19:32, Chris Ridd wrote:
> On 04/05/2022 15:05, Richard Tobin wrote:
>> Presumably there's something that lets you add some hours to a date
>> to handle the timezone.
>
> Yes, plain old arithmetic. Add (1/24) to a date/time value to increase
> it by one hour.
>

Assuming you don't want the time displayed with the offset.

--
Graeme Wall
This account not read.

Re: ISO 8601 timestamps and Numbers

<t50kan$5l4$1@dont-email.me>

 copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=8366&group=uk.comp.sys.mac#8366

 copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!usenet.goja.nl.eu.org!3.eu.feeder.erje.net!feeder.erje.net!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: chrisr...@mac.com (Chris Ridd)
Newsgroups: uk.comp.sys.mac
Subject: Re: ISO 8601 timestamps and Numbers
Date: Thu, 5 May 2022 14:43:51 +0100
Organization: A noiseless patient Spider
Lines: 20
Message-ID: <t50kan$5l4$1@dont-email.me>
References: <0001HW.2821A7B50556C38B70000879F38F@news.individual.net>
<t4u16v$a8n$1@macpro.inf.ed.ac.uk> <t4ugsa$kl8$1@dont-email.me>
<t4uon2$4f0$3@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Thu, 5 May 2022 13:43:52 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="406a249ec1edee988e17acbceaccdf17";
logging-data="5796"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+mslPfO9jSAGWUrzKxhm25AA827/4ZEOQ="
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0)
Gecko/20100101 Thunderbird/91.8.1
Cancel-Lock: sha1:nq5rEWvO9B7zQRtxmNNqUyGUumE=
In-Reply-To: <t4uon2$4f0$3@dont-email.me>
 by: Chris Ridd - Thu, 5 May 2022 13:43 UTC

On 04/05/2022 21:46, Graeme Wall wrote:
> On 04/05/2022 19:32, Chris Ridd wrote:
>> On 04/05/2022 15:05, Richard Tobin wrote:
>>> Presumably there's something that lets you add some hours to a date
>>> to handle the timezone.
>>
>> Yes, plain old arithmetic. Add (1/24) to a date/time value to increase
>> it by one hour.
>>
>
> Assuming you don't want the time displayed with the offset.

Right. But that seems impossible to do while keeping the cell as a
date/time. As a string, sure..

Numbers' function help says quite a few things about what timezone it
assumes in multiple cases. "Good luck" seems like a good summary.

--
Chris

Re: ISO 8601 timestamps and Numbers

<t50sbo$9eb$1@dont-email.me>

 copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=8367&group=uk.comp.sys.mac#8367

 copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: rai...@greywall.demon.co.uk (Graeme Wall)
Newsgroups: uk.comp.sys.mac
Subject: Re: ISO 8601 timestamps and Numbers
Date: Thu, 5 May 2022 17:00:56 +0100
Organization: A noiseless patient Spider
Lines: 28
Message-ID: <t50sbo$9eb$1@dont-email.me>
References: <0001HW.2821A7B50556C38B70000879F38F@news.individual.net>
<t4u16v$a8n$1@macpro.inf.ed.ac.uk> <t4ugsa$kl8$1@dont-email.me>
<t4uon2$4f0$3@dont-email.me> <t50kan$5l4$1@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Thu, 5 May 2022 16:00:56 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="c8c4237d5a76421754e5ba1dc1bff2b7";
logging-data="9675"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/9oaBWPAxAl9I9f80vxb8+YSZS8iZv1MM="
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0)
Gecko/20100101 Thunderbird/91.8.1
Cancel-Lock: sha1:ztcj/LP1pXoREWg1DD/VevBuTTs=
In-Reply-To: <t50kan$5l4$1@dont-email.me>
Content-Language: en-GB
 by: Graeme Wall - Thu, 5 May 2022 16:00 UTC

On 05/05/2022 14:43, Chris Ridd wrote:
> On 04/05/2022 21:46, Graeme Wall wrote:
>> On 04/05/2022 19:32, Chris Ridd wrote:
>>> On 04/05/2022 15:05, Richard Tobin wrote:
>>>> Presumably there's something that lets you add some hours to a date
>>>> to handle the timezone.
>>>
>>> Yes, plain old arithmetic. Add (1/24) to a date/time value to
>>> increase it by one hour.
>>>
>>
>> Assuming you don't want the time displayed with the offset.
>
> Right. But that seems impossible to do while keeping the cell as a
> date/time. As a string, sure..
>
> Numbers' function help says quite a few things about what timezone it
> assumes in multiple cases. "Good luck" seems like a good summary.
>

If you want to keep the offset you could display it in the adjacent cell:

|Date T Time|offset|

--
Graeme Wall
This account not read.

1
server_pubkey.txt

rocksolid light 0.9.7
clearnet tor