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 WEwSDSvnKmU0iAAAG6o9tA:P1 (envelope-from ) for ; Sat, 14 Oct 2023 21:08:27 +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 WEwSDSvnKmU0iAAAG6o9tA (envelope-from ) for ; Sat, 14 Oct 2023 21:08:27 +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 B704A69918 for ; Sat, 14 Oct 2023 21:08:26 +0200 (CEST) Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20230601 header.b=a4mHIHKD; 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=1697310507; 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=2b/NFnCJpG6ZcBYfYtQ5ywAgmlSF3/Q14I/Ayugwbtk=; b=KAZsxWy60iM9DmnxWvJgpGn/rYL3+w6WxIYYRZXPaE+15Qrk7zLL+PwErhgRnl5V5kKvqb QMyRswZFh7o8N/2erlLv77TxqQsbr2GLDF1KBSfEZc2FhedONNFlpHEshHhO37YtLI5mpS 0f2jo9I6kCixdLIh3n3lA/Vqx2t7GHR49nn8xovwJPF3GXolH1+KV0AOw5Tpxqc0BwXNna 9mjL6qqL8IM5lgDhfPmtaMPPpKX5U7/sa6fhuPrOIZejk2ODi0ddAH9tt9SBQVjs7VawUa swmwXtAKQjWfrrHAXdeSv7ji/TKnX2BQkn0pMu2U//nBwuFqEYNY+6fALuGytQ== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1697310507; a=rsa-sha256; cv=none; b=lC7zyfSyUpS6U8BU723DKsn/fD16sCXsSqBdnODgWyWVduzC0xZY9j7uM3HU5KxFkfDLeP 4PgeT3KS+oik1S1l5vo1dOHqkg5VBTLF5HmrdIxisff1+aJNSKCptefWvRATTDVuadfZuP nbEDOeaX9LOimAPXk725T+bBKKn0GPcmO+AJCUrkCg0RLWwH/Z0rr4TWTskugyzMfaXWCz 5qNAJr9fiUmYHHOX4Ti9FWb9DGCHAe8Wpv6JdaO0NOK1M+mTdyS6s2L/u1Z+Vuck7Kxipq bOav3a1QbZ9Yp0hPspV8qqyCCNan5SFroavJYC6g4NG9ZzO6z6EbwAb4d7PZ/g== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20230601 header.b=a4mHIHKD; 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 1qrjyx-0001kl-Qn; Sat, 14 Oct 2023 15:07:27 -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 1qrjyv-0001kP-Mb for emacs-orgmode@gnu.org; Sat, 14 Oct 2023 15:07:25 -0400 Received: from mail-wm1-x336.google.com ([2a00:1450:4864:20::336]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1qrjyt-0004Ey-TA for emacs-orgmode@gnu.org; Sat, 14 Oct 2023 15:07:25 -0400 Received: by mail-wm1-x336.google.com with SMTP id 5b1f17b1804b1-40666aa674fso32134225e9.0 for ; Sat, 14 Oct 2023 12:07:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1697310442; x=1697915242; 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=2b/NFnCJpG6ZcBYfYtQ5ywAgmlSF3/Q14I/Ayugwbtk=; b=a4mHIHKD8TlmNHIL2c2LJtZoJipPvEMZ4fk4xNr+JY6Ph98pkiB09ATroWVGCJqx07 7hqLnQd4R7dGgSYsMYrSntVZQOKgQfu3L1Nuzhb2A25r/2d3hPOkVbzlI1wKKgcVaGvl 3fozuyoeBaXh+NDPWsfG3m9naifNH9EOmNtB7y930iNnM/j3Ga+hhiijkXsN6nNCdx7g B0pT+22esVJWE40Qi8PC0XJ9fEx9ACz7CuumvLBcIMgvNZ4abbw5ZCtBpGhGmTVTimw3 GHLPf9VnFHSExSz/d7cw8OULiraGAQBgT3QQ7DhSQ65g5mnoziV3Poq/65ZIbjxhyqhl wbOg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1697310442; x=1697915242; 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=2b/NFnCJpG6ZcBYfYtQ5ywAgmlSF3/Q14I/Ayugwbtk=; b=ZsBSxf4w6WcAgJhYrzDgIqJAPu58vnR/HnanllSv6ZNUm+BAzlzDW8OfrprtoS5Wtc aW7wLWpJQUfVKckahg+1i9UBiZoO0T4EH/WqNhFZOGtlkH4lBCXL4qrES9iIZ/KIMO6G +K1UwHuVi/O8v02SdSb7fRxC/xdGwd0CAFYsztoHPJZUs3K8sLDaIr9qXjB9UjB2u7Av Wg0TreaGp7QZHF8WE9I7vWOldWSz3b+E5K85owHoqkfnwsot0GKTtu3QoQU8pyyAa5aA VorqBzV1aeQVr1ZsiqZ+DhZmxDBv2+DMgtm8vPo8lA3EPF0NMyz3QrOIY6lVfqOLC9ZW F2Ew== X-Gm-Message-State: AOJu0YxynaxGbBkmISrmuut+dSCJ5qEJWCDJai/yqsGmPLB+RYx4pzta WB/+evCJ/uauCoHKozwbFlLnA+ucXd7QECdIkto= X-Google-Smtp-Source: AGHT+IHTSeiR4c+C8Sk7xUzROinahzn/shBkMiusiVqbZ4jrZfRUHkfeAFoiKE3jkwgUnGQznOKE5POND91tWNZApok= X-Received: by 2002:a05:600c:b91:b0:406:84cb:b014 with SMTP id fl17-20020a05600c0b9100b0040684cbb014mr25108090wmb.22.1697310442169; Sat, 14 Oct 2023 12:07:22 -0700 (PDT) MIME-Version: 1.0 References: <87h6mtavg6.fsf@localhost> In-Reply-To: <87h6mtavg6.fsf@localhost> From: =?UTF-8?Q?S=C5=82awomir_Grochowski?= Date: Sat, 14 Oct 2023 21:07:10 +0200 Message-ID: Subject: Re: org-columns--summary-mean-time [BUG] To: Ihor Radchenko Cc: emacs-orgmode@gnu.org Content-Type: multipart/alternative; boundary="000000000000faa8c90607b1e1c6" Received-SPF: pass client-ip=2a00:1450:4864:20::336; envelope-from=slawomir.grochowski@gmail.com; helo=mail-wm1-x336.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: -9.06 X-Migadu-Queue-Id: B704A69918 X-Migadu-Scanner: mx0.migadu.com X-Migadu-Spam-Score: -9.06 X-TUID: DL1V3ryZAOqQ --000000000000faa8c90607b1e1c6 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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. On Sat, Oct 14, 2023 at 8:50=E2=80=AFPM Ihor Radchenko wrote: > S=C5=82awomir Grochowski writes: > > > I'm not sure if this is a bug or I need to change something? > > > > (org-columns--summary-mean-time '("17:00" "18:00") nil) ;=3D> "17:30" ;= ok > > (org-columns--summary-mean-time '("22:00" "02:00") nil) ;=3D> "12:00" ; > > should be 00:00 > > (org-columns--summary-mean-time '("22:00" "03:00") nil) ;=3D> "12:30" ; > > should be 00:30 > > The function computes mean duration. I see nothing wrong. > > -- > Ihor Radchenko // yantar92, > Org mode contributor, > Learn more about Org mode at . > Support Org development at , > or support my work at > --000000000000faa8c90607b1e1c6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
In ex. I want to have an average time when I go to=C2=A0be= d.
So on Monday I went to bed at 22:00 and on Tuesday at 02:00.=C2=A0
So the average time would be midnight 00:00.
But it retu= rns 12:00 which is noon.=C2=A0



=
=C2=A0

On Sat, Oct 14, 2023 at 8:50=E2=80=AFPM Ihor Radchen= ko <yantar92@posteo.net> w= rote:
S=C5=82awo= mir Grochowski <slawomir.grochowski@gmail.com> writes:

> I'm not sure if this is a bug or I need to change something?
>
> (org-columns--summary-mean-time '("17:00" "18:00&qu= ot;) nil) ;=3D> "17:30" ; ok
> (org-columns--summary-mean-time '("22:00" "02:00&qu= ot;) nil) ;=3D> "12:00" ;
> should be 00:00
> (org-columns--summary-mean-time '("22:00" "03:00&qu= ot;) nil) ;=3D> "12:30" ;
> should be 00:30

The function computes mean duration. I see nothing wrong.

--
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>
--000000000000faa8c90607b1e1c6--