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

Creating a macro - Writing a Script - Using the API

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

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?

Thankyou for any good news about this
But if this is not possible, then I apologize for stupid question

Ponny
Last edited by Ponny on Sat Apr 22, 2017 8:15 pm, edited 1 time in total.
MS Windows 10: OpenOffice 4.1.3

Ponny

Posts: 117
Joined: Sun Jun 21, 2009 7:34 pm
Location: Mystical Kingdom of Krakovo

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

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
(12.06 KiB) Downloaded 52 times
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.5 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.2; AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.

Zizi64
Volunteer

Posts: 7914
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

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

getSystemTicks
Openoffice 4.1.2
Windows 8
JeJe
Volunteer

Posts: 483
Joined: Wed Mar 09, 2016 2:40 pm

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

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`
MMove 1.0.6
• Extension for easy, exact positioning of shapes, pictures, controls, frames ...
my current system
• Windows 7 OOo, AOO, LOLinux Mint OOo, AOO, LO
F3K Total
Volunteer

Posts: 904
Joined: Fri Dec 16, 2011 8:20 pm

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

It works!

Thank you

Ponny
MS Windows 10: OpenOffice 4.1.3

Ponny

Posts: 117
Joined: Sun Jun 21, 2009 7:34 pm
Location: Mystical Kingdom of Krakovo

Return to Macros and UNO API

### Who is online

Users browsing this forum: BenDev and 6 guests