Time calculation


I can't find a way to add eg 30 minutes to a time field like 12:45.

So how can I add or substract minutes to hours ?



Dear Arthur,

we currently don't have a node which can do that job. But it is under planing.


However you can use the java snippet to return the string, and convert it with a string to date time back.


Here's an examplary code for the java snippet, which add 30minutes to the column


SimpleDateFormat dataFormat = new SimpleDateFormat("yyyy-MM-dd'T'hh:mm:ss");

int min = 30;

Date value;
try {
  value = dataFormat.parse($Date and time$);
} catch (Exception e) {
  throw new Abort("Unable to parse value: " + $Date and time$, e);

long t = value.getTime();
t+= 1000*60*min;
DateFormat df = DateFormat.getDateInstance();

return dataFormat.format(value);

Hi Iris,

When are you planning to release this node?

I have some columns with time data and I want to sum up them by columns or by rows. How can I do it?

Thanks for your help.

I agree this is a much needed node. I have wanted to add 1 day or 1 week to some date times but been unable too due my java phobia.


Also when do we get this pink Iris node :-)