Hi,
Have you tried the numeric equivalent of your times? I believe the if
expression is interpreted as returning a number of seconds. The
following table format line works for me:
#+TBLFM: $4=$3$2;T::$5=if($4 0,29880,0);T::$6=$4$5;T
HTH,
eric

: Eric S Fraga (0xFFFCF67D), Emacs 24.3.1,
Hi Eric,
Eric S Fraga e.fr...@ucl.ac.uk writes:
Hi,
Have you tried the numeric equivalent of your times? I believe the if
expression is interpreted as returning a number of seconds. The
following table format line works for me:
#+TBLFM: $4=$3$2;T::$5=if($4 0,29880,0);T::$6=$4$5;T
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* 
+++++

Hi Seb,
Sebastien Vauban svan...@mygooglest.com
writes:
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* 
Loris Bennett wrote:
Sebastien Vauban writes:
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* 
Sebastien Vauban svan...@mygooglest.com
writes:
Loris Bennett wrote:
Sebastien Vauban writes:
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* 
Loris Bennett wrote:
Sebastien Vauban svan...@mygooglest.com writes:
Loris Bennett wrote:
Sebastien Vauban writes:
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* 
Hi,
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* 
+++++
 [20140106 Mon]  8:00 