I have unsubscribed numerous times. Stop sending me your junk!
-Original Message-
From: Harvey Nimmo
Sent: Thursday, July 11, 2019 1:55 PM
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Help with formula - number conversion
On Thu, 2019-07-11 at 14:05 -0400, Tanstaafl
On Fri, 2019-07-12 at 13:00 -0400, Tanstaafl wrote:
> On Thu Jul 11 2019 15:12:05 GMT-0400 (Eastern Standard Time), Harvey
> Nimmo wrote:
> > Sorry, Tanstaafl!
> >
> > There is a slight error in the above. The formula should read
> > =HOUR(A1)*60+MINUTE(A1)+ROUND(SECOND(A1)/60,0)
> >
> > 'SEC'
At 14:05 11/07/2019 -0400, Charles Marcus wrote:
I need some help with converting a number (in a text field) to a
different type. The type of number is time, and it is in the form
of: hh:mm:ss I need to convert this to just minutes, rounded up, so
if ss is more than 30 it adds another minute.
On Thu Jul 11 2019 15:12:05 GMT-0400 (Eastern Standard Time), Harvey
Nimmo wrote:
> Sorry, Tanstaafl!
>
> There is a slight error in the above. The formula should read
> =HOUR(A1)*60+MINUTE(A1)+ROUND(SECOND(A1)/60,0)
>
> 'SEC' is the secant function. Also 'MIN' would also be wrong since it
> ca
Hi Harvey,
>>
> Yes, I can enter data directly into a table.
Now create a form (without subform) by the wizard for this table.
Could you enter data there? Then have a look to the datasource of the
other forms ...
Regards
Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Communi
On Fri, 2019-07-12 at 16:08 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> > However, whereas I can now connect successfully with jdbc to the
> > database, my existing (LO) input forms won't let me change the
> > data.The
> > form controls are completely deactivated.
>
> Open one of the tables
Hi Harvey,
>
> However, whereas I can now connect successfully with jdbc to the
> database, my existing (LO) input forms won't let me change the data.The
> form controls are completely deactivated.
Open one of the tables, not a form. Could you input data here? If not:
Base is missing a primary k
On Thu, 2019-07-11 at 21:47 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
> have the same system here and have written down all what I have
> tested here:
> http://robert.familiegrosskopf.de/lo_hb_xhtml/Base_02_DatenbankErstel
> len.xhtml#__RefHeading__875_19302748411
>
> Its part of the German Ba