Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

julruiz123
Contributor

Seconds between two Times

Hi,

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

Thanks

Tags (2)
1 Solution

Accepted Solutions

Re: Seconds between two Times

Hi,

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

BI Consultant

Comex Grupo Ibérica

2 Replies

Re: Seconds between two Times

Hi,

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

BI Consultant

Comex Grupo Ibérica

julruiz123
Contributor

Seconds between two Times

Thanks!

You're right