Page 1 of 1

### [Solved] Time seconds function - two decimals output

Posted: Fri Apr 21, 2017 4:14 pm
Meow

About time functions. I remember in Word Basic from MS Word 6, function Second returns seconds and 100 miliseconds and 10 miliseconds. Something about this example: "3,14". Seconds of corse. From input variable with serial date&time.

Now in OpenOffice Basic (OpenOffice 3.1.2) function Second returns only seconds without decimals. Is there any hope to get time - seconds with two decimals? Maybe 3?

But if this is not possible, then I apologize for stupid question

Ponny

### Re: Time seconds function - two decimals output

Posted: Fri Apr 21, 2017 9:22 pm
The Cell Function NOW() supports the fractions of the seconds. You can calculate the seconds and the fraction part of the seconds by a macro or by some cell functions.

Note: The resolution of the StarBasic function NOW() is 1 second. There is no fraction.

SecFrac.ods

### Re: Time seconds function - two decimals output

Posted: Fri Apr 21, 2017 10:01 pm
getSystemTicks

### Re: Time seconds function - two decimals output

Posted: Sat Apr 22, 2017 10:11 am
Code: Select all   Expand viewCollapse view
`Sub F_get_NOW as string   oFunctionAccess = createUnoService("com.sun.star.sheet.FunctionAccess")   dDateTime = oFunctionAccess.callFunction("NOW", Array())   dTime = dDateTime - Int(dDateTime)      sTime = Format(dTime,"HH:MM:SS.00")   msgbox ("Current Timestamp:" & CHR(13) & sTime,64,"Date Time -> seconds with two decimal places")End Sub`

### Re: Time seconds function - two decimals output

Posted: Sat Apr 22, 2017 8:14 pm
It works!

Thank you

Ponny