I have a silly table I am planning to use to teach myself a little bit about R; it contains durations measured in minutes and seconds:
* Kayaking Log
| 500m Trial | <2016-09-14 Wed> | <2016-09-15 Thu> | Mean |
|------------+------------------+------------------+----------|
| 1 | 00:02:48 | 00:02:34 | 00:02:48 |
| 2 | 00:02:38 | 00:02:47 | |
| 3 | 00:02:42 | 00:02:42 | |
| 4 | 00:02:36 | 00:02:40 | |
| 5 | 00:02:58 | 00:02:37 | |
|------------+------------------+------------------+----------|
| MEAN | 00:02:44 | 00:02:40 | |
#+TBLFM: $2=vmean(@address@hidden);T::$3=vmean(@address@hidden);T::$4=vmean($2..$-1);T
I have a bunch of questions but will start with what is maybe the most basic: can I write durations in minutes and seconds only? the extra 00: is sort of annoying to type when I am tired.
Later I'll want to think about the best way to turn this data into a plot of fastest, slowest, and mean times day-to-day. But not tonight, I'm beat!