function to convert time to Millisecond

[#1]

Dear Team, Is there is any function to convert Time into Millisecond Thanks in Advance Jitendra

[jonathandienst]

Hi

If the source value is a time/date value, then use this to convert MyTime to ms:

     =Frac(MyTime) * (24*60*60*1000)

If its an interval and you want to include the days in the interval, use the factor without the Frac:

     =MyTime * (24*60*60*1000)

HTH

Jonathan

[#3]

hi

try according to  this

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

[ashfaq_haseeb]

Try this

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

Regards

ASHFAQ