From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Deniz Dogan Newsgroups: gmane.emacs.help Subject: org-mode time spreadsheet Date: Fri, 9 Jan 2009 00:09:16 -0800 (PST) Organization: http://groups.google.com Message-ID: NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Trace: ger.gmane.org 1231513490 7127 80.91.229.12 (9 Jan 2009 15:04:50 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Fri, 9 Jan 2009 15:04:50 +0000 (UTC) To: help-gnu-emacs@gnu.org Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Fri Jan 09 16:06:01 2009 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by lo.gmane.org with esmtp (Exim 4.50) id 1LLIvH-0006pM-0z for geh-help-gnu-emacs@m.gmane.org; Fri, 09 Jan 2009 16:05:51 +0100 Original-Received: from localhost ([127.0.0.1]:58901 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LLIu0-0007Av-V9 for geh-help-gnu-emacs@m.gmane.org; Fri, 09 Jan 2009 10:04:00 -0500 Original-Path: news.stanford.edu!headwall.stanford.edu!news.glorb.com!postnews.google.com!s9g2000prm.googlegroups.com!not-for-mail Original-Newsgroups: gnu.emacs.help Original-Lines: 32 Original-NNTP-Posting-Host: 212.209.35.73 Original-X-Trace: posting.google.com 1231488556 14825 127.0.0.1 (9 Jan 2009 08:09:16 GMT) Original-X-Complaints-To: groups-abuse@google.com Original-NNTP-Posting-Date: Fri, 9 Jan 2009 08:09:16 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: s9g2000prm.googlegroups.com; posting-host=212.209.35.73; posting-account=k_QfHQoAAACfswK3kvc6w0qLbkOOWev5 User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5,gzip(gfe),gzip(gfe) Original-Xref: news.stanford.edu gnu.emacs.help:165866 X-Mailman-Approved-At: Fri, 09 Jan 2009 10:03:10 -0500 X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.help:61205 Archived-At: I hope this formats well, because I'm posting this through Google Groups... Anyways... Hi I'm trying to have an org-mode table which shows a working day (not necessarily every normal work day, I enter these myself) and when I got in, when I went out to lunch, when I came back, and when I left for the day. I want the last column "TOT" to display how long I was at work minus the time I was out for lunch. I'm well aware of timeclock-in, timeclock-out, as well as org-mode's C- c C-x C-i/C-o functionality, but I really want to have it as a spreadsheet. However, it seems that calc isn't that good at working with times, so now I'm asking you for help. Is this possible to do with plain org-mode? If so, what am I doing wrong? Below is the file I'm currently using and it seems that it doesn't realize that the values are actually timestamps. | DATE | IN | LUNCH FROM | LUNCH TO | OUT | TOT | |------------+-------+------------+----------+-------+--------| | THU 18 NOV | 9:30 | 12:30 | 13:40 | 14:20 | 2:5 | | FRI 31 DEC | 10:00 | 12:00 | 14:00 | 16:00 | #ERROR | | SAT 1 JAN | 8:00 | 12:00 | 12:30 | 16:00 | #ERROR | | MON 5 JAN | 9:00 | 12:45 | 13:15 | 16:00 | #ERROR | | TUE 6 JAN | 16:30 | 17:30 | 18:30 | 22:30 | 1:5 | | WED 7 JAN | 9:00 | 12:00 | 12:40 | 20:45 | 11:05 | | THU 8 JAN | 12:30 | 15:00 | 15:40 | 18:30 | | | FRI 9 JAN | 9:00 | | | | | #+TBLFM: $6=$5-$2 Deniz