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 sva-n...@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 sva-n...@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 sva-n...@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* |
|--+++--++--|
| [2014-01-06 Mon] | 8:00 |