How to convert seconds into a number/integer

[#1]

Hi all,

What do I need to do to this expression to convert it into a number?

Interval(SchedArriv-ActualArrive,'ss') .

I've tried a SUM and a NUM, but it returns incorrect values.

Thanks

[Gysbert_Wassenaar · Accepted solution]

Leave out the interval. Dates are numbers so simply subtracting two dates from each other will result in another number. If you want you can use the num function to specify a format: num(ScheArriv-ActualArrive,'#,###.00')

[#3]

Thanks again, Gysbert!