### Re: [O] Conditional in table formula with times

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,

### Re: [O] Conditional in table formula with times

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

### Re: [O] Conditional in table formula with times

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* | |--+++--++--| |

### Re: [O] Conditional in table formula with times

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* |

### Re: [O] Conditional in table formula with times

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* |

### Re: [O] Conditional in table formula with times

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* |

### Re: [O] Conditional in table formula with times

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* |

### [O] Conditional in table formula with times

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 |