Time difference in millisecond

[#1]

Dear Team,

i am using interval function to get difference between two times in second/minutes/ and hour by below mention formaula

1) =interval(Timestamp#('12:00:00.010','hh:mm:ss.fff') - Timestamp#('11:00:00.010','hh:mm:ss.fff'),'s')      ANS : 3600

2) =interval(Timestamp#('12:00:00.010','hh:mm:ss.fff') - Timestamp#('11:00:00.010','hh:mm:ss.fff'),'mm')  ANS :  60

3) =interval(Timestamp#('12:00:00.010','hh:mm:ss.fff') - Timestamp#('11:00:00.010','hh:mm:ss.fff'),'hh')    ANS : 01

i want to get the difference in milliseconds like :

=interval(Timestamp#('12:00:00.010','hh:mm:ss.fff') - Timestamp#('11:00:00.010','hh:mm:ss.fff'),'fff')

Kindly let me know how can we do this.

Regards,

JKV

[Gysbert_Wassenaar · Accepted solution]

Use sfff as format string:

=interval(Timestamp#('12:00:00.010','hh:mm:ss.fff') - Timestamp#('11:00:00.010','hh:mm:ss.fff'),'sfff')

[#3]

See this

[MarcoWedel]

(Timestamp#('12:00:00.010','hh:mm:ss.fff') - Timestamp#('11:00:00.010','hh:mm:ss.fff')*86400000

Regards

Marco

[MarcoWedel]

(Timestamp#('12:00:00.010','hh:mm:ss.fff') - Timestamp#('11:00:00.010','hh:mm:ss.fff'))*86400000

[#6]

Thanks