Or, even better, just divide by the HMS form for 1 second (0@ 0' 1"): | - | - | - | 1@ 11' 37" | - | - | - | 4297 | #+TBLFM: $8=$4 \ 0@ 0' 1"
Note that \ is integer division, so there is no need for a format conversion Will P.S. I highly recommend reading the [[info:calc#Basic Arithmetic]] section of the calc manual On Fri, May 2, 2014 at 10:01 PM, William Henney <when...@gmail.com> wrote: > Hi Ryan > > Convert to degrees, then multiply by 3600: > > | - | - | - | 1@ 11' 37" | - | - | - | 4297 | > #+TBLFM: $8=3600 deg($4); %d > > Cheers > > Will > > > > On Fri, May 2, 2014 at 8:52 PM, Ryan Moszynski > <ryan.moszyn...@gmail.com>wrote: > >> If an org table cell contains the HMS 1@ 11' 37" >> >> is there an easy way to get the total (time)seconds? >> >> (1*3600 + 11*60 + 37 = 4297) >> >> >> if $4 = 1@ 11' 37" >> >> how do I get $8 = 4297? >> >> thanks >> >> ryan >> >> -- >> He felt that his whole life was some kind of dream and he sometimes >> wondered whose it was and whether they were enjoying it. - Douglas >> Adams >> >> > > > -- > > Dr William Henney, Centro de Radioastronomía y Astrofísica, > Universidad Nacional Autónoma de México, Campus Morelia > -- Dr William Henney, Centro de Radioastronomía y Astrofísica, Universidad Nacional Autónoma de México, Campus Morelia
