Time difference between two timestamps

[#1]

Hi All,

Kindly help me to resolve the difference between two timestamps

Ex:

      column 1 :  2013-05-17 22:14:15

      column 2:   2013-05-17 22:20:15

Tried out the following option (Mentioned earlier in the community but it didnt work ,returns no value)

=

Interval(NUM(Date#(finished, 'DD-MM-YYYY hh:mm:ss tt')-num(Date#(started, 'DD-MM-YYYY hh:mm:ss tt'))))

Thanks in advance

[Clever_Anjos]

dont use tt since your using 24h period and adjust you date format

Interval(NUM(Date#(finished, 'YYYY-MM-DD hh:mm:ss')-num(Date#(started, 'YYYY-MM-DD hh:mm:ss'))))