Discussion board where members can get started with QlikView.
In a table i have two times, what i need is to know how many seconds have elapsed between the two times.
With this sintax i get the hour and minuts but i need the seconds.
interval([Hora Fin] - [Hora Inico]) as Time
Go to Solution.
You are almost there! Use the following format to show the result in seconds:
Interval([Hora Fin] - [Hora Inicio], 's') as Time
The 's' will make the Interval() be displayed in seconds.
Hope that helps.
Miguel Angel Baeyens
Comex Grupo Ibérica