Operation with data time format

[#1]

Hi all,

How can I make the difference between two fields time format and get the result in seconds?

Sample:

(Time (EndTime, 'hh.mm.ss')) - (Time (StartTime, 'hh.mm.ss'))

Thank All

[#2]

Try this.

Interval((Time (EndTime, 'hh.mm.ss'))-(Time (StartTime, 'hh.mm.ss')), 'SS')

[tresB]

Try inteval(), like:

Interval(

(Time (EndTime, 'hh.mm.ss')) - (Time (StartTime, 'hh.mm.ss'))

, 's')