How to convert Time into millisecond

[#1]

Dear All, i want to know how to convert Time "00:00:00.000" to Millisecond. Ex : if time difference of two time 11:00:00.010 - 11:00:01.020 = 00:00:01.010. i want to show it as 1010 Please help

[Gysbert_Wassenaar · Accepted solution]

=Interval(Time#('11:00:01.020','hh:mm:ss.fff')-Time#('11:00:00.010','hh:mm:ss.fff'),'sfff')

[#3]

Thanks Gysbert

[#4]

instead of Interval() if i use Timestamp() then also its working.. then what is different between these two...

[Gysbert_Wassenaar]

The difference is that timestamp is a point in time, not an duration between two points in time. You can see this if you make a timestamp out of 26 hours. Try these two in text boxes:

=interval(26/24,'hh')

=timestamp(26/24,'hh')

[MarcoWedel]

For sorting purposses you might also wish to try the expression:

=(Time#('11:00:01.020','hh:mm:ss.fff')-Time#('11:00:00.010','hh:mm:ss.fff'))*86400000

Hope this helps

Regards

Marco

[#7]

Thanks 🙂

[MarcoWedel]

You're welcome.

Regards

Marco

[MarcoWedel]

Hi,

I noticed some effects due to the limited resolution of real values, so the result has to be converted to an integer:

=Round((Time#('11:00:01.020','hh:mm:ss.fff')-Time#('11:00:00.010','hh:mm:ss.fff'))*86400000)

hope this helps

regards

Marco