ADD and SUBTRACT Time

[rustyfishbones]

In Qlikview you can use ADDMONTHS and ADDYEARS to subtract or add months and years

Is there a similar function for time?

regards

Al

[swuehl]

Time and date are numbers in QlikView, just the text part is formatted accordingly.

So you can use maketime() etc, to create a time value (or just enter the number in fraction of days) and use arithmetic operations + and -.

[jonathandienst]

Remember that time is the fractional part of the datetime number. So 0.25 = 06:00 when formatted as time.

As swuehl said, its just simple arithmetic, so

To add 1 hour, add 1/24

To add 1 minute, add 1/1440

HTH

Jonathan