date and time to date and
time values.
On 13 Mar 2022 at 11:03, Michael H wrote:
From: Michael H
Date sent: Sun, 13 Mar 2022 11:03:32 -0500
Subject:Re: [libreoffice-users] Spreadsheet question
To: "Rogier F. van Vlissingen"
Copies to: "Micha
t; > 0
> > K
> > CO2
> > L
> > 10
> > M
> > HCHO
> > N
> > 0.001
> > O
> > TVOC
> > P
> > 0
> > Q
> > >0.3DustNum
> > R
> > 0
> > S
> > >0.5DustNum
> > T
> > 0
> > U
&g
> AA
> >10DustNum
> AB
> 0
> On 13 Mar 2022 at 9:30, Rogier F. van Vlissingen wrote:
> From:"Rogier F. van Vlissingen"
> Date sent: Sun, 13 Mar 2022 09:30:49 -0400
> Subject: Re: [libreoffice-users] Spreadsheet question
> To:
3 Mar 2022 at 9:30, Rogier F. van Vlissingen wrote:
From: "Rogier F. van Vlissingen"
Date sent:60;Sun, 13 Mar 2022 09:30:49 -0400
Subject: ;Re: [libreoffice-users] Spreadsheet
question
To: 0;"Michael D. Setzer II"
Copies to:60;users@global.libreoffice.org
> Funny compli
Vlissingen"
> Date sent: Sun, 13 Mar 2022 09:05:56 -0400
> Subject: Re: [libreoffice-users] Spreadsheet question
> To: David Lynch
> Copies to: users@global.libreoffice.org
> > wow... I had never used that function before...
> > >
>
t;> Loaded the csv file with libreoffice and click on space and
>>> other boxes and entered :.
>>> That brings in columns A thru AB.
>>>
>>>
>>> On 13 Mar 2022 at 9:05, Rogier F. van Vlissingen wrote:
>>>
>>> From: "
),MID(B2,5,2),RIGHT(B2,2))
In ae1 put D
In ae2 put
=TIME(INT(D2/100),MOD(D2,100),0)
On 13 Mar 2022 at 9:05, Rogier F. van Vlissingen wrote:
From:"Rogier F. van Vlissingen"
Date sent:Sun, 13 Mar 2022 09:05:56 -0400
Subject:Re: [libreoffice-users] Spreadsheet
question
To:David Lyn
and
>> other boxes and entered :.
>> That brings in columns A thru AB.
>>
>>
>> On 13 Mar 2022 at 9:05, Rogier F. van Vlissingen wrote:
>>
>> From: "Rogier F. van Vlissingen"
>>
>> Date sent: Sun, 1
05:56 -0400
> Subject: Re: [libreoffice-users] Spreadsheet
> question
> To: David Lynch
> Copies to: users@global.libreoffice.org
>
> > wow... I had never used that function before...
> > >
> > > I am not quite there
00
Subject: Re: [libreoffice-users] Spreadsheet
question
To: David Lynch
Copies to: users@global.libreoffice.org
> wow... I had never used that function before...
> >
> > I am not quite there yet, however, but at least this is a path.
wow... I had never used that function before...
>
> I am not quite there yet, however, but at least this is a path. Here is an
> example of one of the strings
>
> Date:20220302 Time:1631 PM1.0:000 PM2.5:000 PM10:000 CO2:0010 HCHO:0.001
> TVOC:0.000 >0.3DustNum:0 >0.5DustNum:0 >1.0DustNum:00
This is more of a generic question.
I am getting information uploaded from a microSD which is a text string of
about 10 variables.
I am at a loss how to convert this into spreadsheet data, with rows and
columns. I there a function to do this???
TXT file, and each string is:
Var1: value1 Var2: va
On 6/7/2012 2:07 PM, Steve Edmonds wrote:
Hi.
I might be doing something similar tracking expenditure but can't really
visualise your layout.
I have a column that would be the completion date of each task, that in your
case would be the end date of the previous task + task duration + slippage o
On 2012-06-08 05:48, Eric S. Johansson wrote:
I'm using a spreadsheet to track a project (yes I know not a good idea
but that's what the customer wants). Each task is listed with certain
number of days plus a slip factor. I calculate the project completion
date by summing the number of days a
I'm using a spreadsheet to track a project (yes I know not a good idea but
that's what the customer wants). Each task is listed with certain number of days
plus a slip factor. I calculate the project completion date by summing the
number of days and the slope factor and add that to the previous
15 matches
Mail list logo