Seconds between two Times

[julruiz123]

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

[Miguel_Angel_Baeyens · Accepted solution]

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]

Thanks!

You're right