From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp10.migadu.com ([2001:41d0:403:478a::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms8.migadu.com with LMTPS id mAk6EJDsKmW0fwEAG6o9tA:P1 (envelope-from ) for ; Sat, 14 Oct 2023 21:31:28 +0200 Received: from aspmx1.migadu.com ([2001:41d0:403:478a::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp10.migadu.com with LMTPS id mAk6EJDsKmW0fwEAG6o9tA (envelope-from ) for ; Sat, 14 Oct 2023 21:31:28 +0200 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id CAA476A2A8 for ; Sat, 14 Oct 2023 21:31:27 +0200 (CEST) Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20230601 header.b=MxSfmPgo; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; dmarc=pass (policy=none) header.from=gmail.com ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1697311888; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=DeF1BN6ZMBXaw5l/o8CUiRNqAQi8LshrTy2ekKFhUhU=; b=U9zh9F0aH8CYK6rms5ttUeNkde/pChX1UgRvoRcQcYmD++nvf7LXzqqWOCWsoOhgewy+zH 8lIVcqdgsTL+c7ikH1yt3Pe06h6dcr0qokIOGjbtEbGgxTZNo11rqW1kNTsUZWuxlZu5JI 9KwtwYvDOKGat2Dz3qlBSkqP6MQM/kTnCiaooBETOZWGJVltBuEQUx/P4F/+QApGOnMhWJ bu9ToCbht9fB9xFWMu+cnMhwzFIEaQUWwnVEkRHDF7IIcr0R/1bF5IzRf6qV99GZZeEhG6 0/PxgUDNU438eAUyEXx+nYscclZTzoX7hW98JsknoZWHZTYryWUwquB+70ZHqA== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1697311888; a=rsa-sha256; cv=none; b=YVVhlHZEOTaFV94KFDyr9yfxNptdKq5fDOFw0O5GnFyhFTSo1gdp46BKdH642r33KhOLG/ 8w2c39Ps3/xa8t3P2Nf4Yb+eKnk4MKpeYGHi8l0NVJb2UmR3lQ2R1z94zIcacX5BFOl5Ve F5N18f8UX/yhEhEaAC//xe3PzsgihvhtRQxJWuxPuGg16nJlz249wEVqk245lNBkH+++XH HanwQIsc8+aRbtWLDrzQ6JwCvidoWW5G75Kzl76ZVyD4yUk4nblQXAw52Eh23J92rfqm40 Y7K0U3URm+19mZ5YcRFXUw6RRo2s6EU/uA3jxc96wdSXkqTccbh7wZWeroNu9g== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20230601 header.b=MxSfmPgo; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; dmarc=pass (policy=none) header.from=gmail.com Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1qrkLE-0000E8-HA; Sat, 14 Oct 2023 15:30:28 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1qrkKz-0000D2-DZ for emacs-orgmode@gnu.org; Sat, 14 Oct 2023 15:30:13 -0400 Received: from mail-wm1-x330.google.com ([2a00:1450:4864:20::330]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1qrkKx-00089Q-ND for emacs-orgmode@gnu.org; Sat, 14 Oct 2023 15:30:13 -0400 Received: by mail-wm1-x330.google.com with SMTP id 5b1f17b1804b1-40566f89f6eso37043525e9.3 for ; Sat, 14 Oct 2023 12:30:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1697311809; x=1697916609; darn=gnu.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=DeF1BN6ZMBXaw5l/o8CUiRNqAQi8LshrTy2ekKFhUhU=; b=MxSfmPgoaTL93VuU38SmfpO7RmpXx1YC4mmm+UKvtLH3NAYPD91iz3rfFrF9lPXTEo VazGMWuasVetGtsGmnzaY78prlARyBL32myNcW00dCVqI7CrJ2gkqU3/QUtbPaaUdGL2 d3/anGVMJekILBcU+xGXQAaZ2/DosHnFhksAQGBM68QBj9aK4/DKW+/NK4abxvsi9QlY Oub2WMmjYz99daotA9N50fXXqt168/GCi8kYy7ek3IrbplwK+SjyM/pS0TQXEwGQBrxA RgAgQh3q0lbuGeOMRltcjrdCkyMyAwdDhUr+Qen6zNGp6GTKypwJ76p0RJOAGgZqmJtD KMUg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1697311809; x=1697916609; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=DeF1BN6ZMBXaw5l/o8CUiRNqAQi8LshrTy2ekKFhUhU=; b=Z9OmRZNVg36c0zh6085Uw76Wzr6KybvpMRTq9IS9n1ouanq0AurE4Im94lrn2FH9tA Ui7CqwQ107Unz/gS/KA6AriHtm1f+nC1BVmyJ5443GMk0xKXA8NPPG5Vj3wCGEdicsZT ntsOZF9F3Kj0DAmfqaJgQ4aVPaMRwJ8WcZIc8Uj6UvHMteMiZYgdFjA56GhtxamIuOjf 0Udu/JS7HJs09AzathJ182tPJdznGJQ7yYWRJfY9OYgMfTUEOjecLuz++IbFaA3Ivn/D izs64qZnd6hCgNNgO+FlQPVtw/ZJ7no+hLeQE+YZekgZfK9FuPmDIPcvopU99FKHPIrG haIg== X-Gm-Message-State: AOJu0YzM44i5z+K8Krtzl/vYwfktJIoQ2lKzq2Oj2rk0EM+Gd0UtcWh8 hK5ZRXWiSUr/Gk7D9X6C334pWtwfpTVY0+sbRXI= X-Google-Smtp-Source: AGHT+IEOhWTGfeYaOC9Vg/c+vaLHyUWl49lvdqsSgkZlETzuNZ4N8DtJ1GI1tKq/zQ0v0zyjHEkDIigZqo5Mufye0fc= X-Received: by 2002:a5d:568e:0:b0:319:867e:97d7 with SMTP id f14-20020a5d568e000000b00319867e97d7mr26615941wrv.52.1697311809106; Sat, 14 Oct 2023 12:30:09 -0700 (PDT) MIME-Version: 1.0 References: <87h6mtavg6.fsf@localhost> <87edhxau3h.fsf@localhost> In-Reply-To: <87edhxau3h.fsf@localhost> From: =?UTF-8?Q?S=C5=82awomir_Grochowski?= Date: Sat, 14 Oct 2023 21:29:58 +0200 Message-ID: Subject: Re: org-columns--summary-mean-time [BUG] To: Ihor Radchenko Cc: emacs-orgmode@gnu.org Content-Type: multipart/alternative; boundary="0000000000007479780607b23392" Received-SPF: pass client-ip=2a00:1450:4864:20::330; envelope-from=slawomir.grochowski@gmail.com; helo=mail-wm1-x330.google.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: emacs-orgmode-bounces+larch=yhetil.org@gnu.org X-Migadu-Flow: FLOW_IN X-Migadu-Country: US X-Spam-Score: -6.61 X-Migadu-Queue-Id: CAA476A2A8 X-Migadu-Scanner: mx0.migadu.com X-Migadu-Spam-Score: -6.61 X-TUID: MB/UOJKZI2ph --0000000000007479780607b23392 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable But I'm talking about: (":mean" . org-columns--summary-mean-time) not ("@mean" . org-columns--summary-mean-age). So this is the right function (":mean" . org-columns--summary-mean-time)? Or do I need to write a new one? On Sat, Oct 14, 2023 at 9:19=E2=80=AFPM Ihor Radchenko wrote: > S=C5=82awomir Grochowski writes: > > > In ex. I want to have an average time when I go to bed. > > So on Monday I went to bed at 22:00 and on Tuesday at 02:00. > > So the average time would be midnight 00:00. > > But it returns 12:00 which is noon. > > As I said, it is because it does not calculate an average time of the > day, but an average duration: > > =E2=80=98@mean=E2=80=99 Arithmetic mean of ages (in days/hours/mi= ns/seconds). > > You can customize `org-columns-summary-types' to have a column summary > you need for your purposes. > > -- > Ihor Radchenko // yantar92, > Org mode contributor, > Learn more about Org mode at . > Support Org development at , > or support my work at > --0000000000007479780607b23392 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
But I'm talking about:
(":mean" . org-co= lumns--summary-mean-time)
not=C2=A0 ("@mean" . org-= columns--summary-mean-age).

So this is the right f= unction (":mean" . org-columns--summary-mean-time)?=C2=A0
Or do I need to write a new one?

On Sat, Oct 14, 2023 at 9:19=E2=80= =AFPM Ihor Radchenko <yantar92@po= steo.net> wrote:
S=C5=82awomir Grochowski <slawomir.grochowski@gmail.com> writes:<= br>
> In ex. I want to have an average time when I go to bed.
> So on Monday I went to bed at 22:00 and on Tuesday at 02:00.
> So the average time would be midnight 00:00.
> But it returns 12:00 which is noon.

As I said, it is because it does not calculate an average time of the
day, but an average duration:

=C2=A0 =C2=A0 =C2=A0=E2=80=98@mean=E2=80=99=C2=A0 =C2=A0 Arithmetic mean of= ages (in days/hours/mins/seconds).

You can customize `org-columns-summary-types' to have a column summary<= br> you need for your purposes.

--
Ihor Radchenko // yantar92,
Org mode contributor,
Learn more about Org mode at <https://orgmode.org/>.
Support Org development at <https://liberapay.com/org-mode>,=
or support my work at <https://liberapay.com/yantar92>
--0000000000007479780607b23392--