From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Sebastien Vauban" Subject: Re: Conditional in table formula with times Date: Fri, 21 Feb 2014 09:50:26 +0100 Message-ID: <864n3s97e5.fsf@somewhere.org> References: <871tywlxci.fsf@hornfels.zedat.fu-berlin.de> Mime-Version: 1.0 Content-Type: text/plain Return-path: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org To: emacs-orgmode-mXXj517/zsQ@public.gmane.org "Loris Bennett" wrote: > I'm trying to keep track of total time spend at work, but I am having > trouble with a conditional in table formula: > > | *Day* | *Came* | *Went* | *Worked* | *Required* | *Diff* | > |------------------+--------+--------+----------+------------+----------| > | [2014-01-06 Mon] | 8:00 | 17:00 | 09:00:00 | 00:00:00 | 09:00:00 | > | [2014-01-07 Tue] | | | 00:00:00 | 00:00:00 | 00:00:00 | > | [2014-01-08 Wed] | 8:10 | 16:30 | 08:20:00 | 00:00:00 | 08:20:00 | > | [2014-01-09 Thu] | 7:55 | 17:05 | 09:10:00 | 00:00:00 | 09:10:00 | > | [2014-01-10 Fri] | 8:00 | 17:05 | 09:05:00 | 00:00:00 | 09:05:00 | > #+TBLFM: $4=$3-$2;T::$5=if($4 > 0,"8:18:00","00:00:00");T::$6=$4-$5;T > > Can anyone enlighten me as to why I get "00:00:00" in the first case? Not answering your question... Just wanted to mention that, for this type of task, you probably should have a look at the "clocking" mechanisms (C-c C-x C-i and the like), and use them to generate tables like the above, or bills for clients, etc. Using proper clocking brings you many advantages, whose main (IMO) is the "clock check" feature, where you can check that you don't have unintended clocking gaps during the day, nor clocking overlap... Best regards, Seb -- Sebastien Vauban