Add time (duration) to timestamp

Add time (duration) to timestamp

[Jarmo Hurri]

Greetings.

Is there a way to add time to a timestamp, say, in a table?

For example, say I have a series of events, each lasting 15 minutes,
starting at a specified time on a specific day. I want to create a table
of them as follows:

| time                       | event |
|----------------------------+-------|
| <2015-12-07 Mon 12:00>     | A     |
| add 15 minutes to above    | B     |
| again, add 15 min to above | C     |

Is there a way to automate the generation of the timestamps of events B
and C?

Jarmo

Re: Add time (duration) to timestamp

[Jarmo Hurri]

Greetings again.

Answering my own question, the following seems to work (15 min is 1/96
of a day):

| time                   | event |
|------------------------+-------|
| <2015-12-07 Mon 12:00> | A     |
| <2015-12-07 Mon 12:15> | B     |
| <2015-12-07 Mon 12:30> | C     |
#+TBLFM: @3$1..@4$1=(<@-1>+(1.0 / 96))

Jarmo

Re: Add time (duration) to timestamp

[Richard Lawrence]

Hi Jarmo,

Jarmo Hurri <jarmo.hurri@iki.fi> writes:

> Answering my own question, the following seems to work (15 min is 1/96
> of a day):
>
> | time                   | event |
> |------------------------+-------|
> | <2015-12-07 Mon 12:00> | A     |
> | <2015-12-07 Mon 12:15> | B     |
> | <2015-12-07 Mon 12:30> | C     |
> #+TBLFM: @3$1..@4$1=(<@-1>+(1.0 / 96))

Have you looked at Org's clocking features? (See "Clocking work time" in
the Dates and Times section of the manual.)

Clocking timestamps go into a drawer, rather than a table, but you can
generate a clock report table.  Depending on what you're trying to do,
that might be a cleaner and more flexible solution.

Best,
Richard