Getting the duration??

[99mel]

Hi all,

Does anyone know of a function to get the duration in seconds from a time in this format: hh:mi:ss.y
y being milliseconds.

I want the following result, 85 seconds from the time:

00:01:25.4 = 85 seconds

Or without the millisecond bit, as I can just search for it and calculate whether to round up or leave the value.

Thanks for any help!

 

[jmarler]

Seconds = 3600*hh + 60*mi + ss + (y/1000) - Jeff Marler B-)

 

[JohnYingling]

Start here
' 86400 60 * 60 * 24
dteExpire = Now + (85 /86400))
' Look at DatePart

http://WWW.VBCompare.Com