And you can tell the difference between a 'text' date and a 'date value'
date by turning on "value highlighting" menu-->View-->Value Highlighting
Blue is a value or date value,
Green is a formula,
Black (or the regularly formatted color if you've painted your spreadsheet)
is text.
On Sun, Dec
and my 1st attempt at logic is horribly flawed for the DATE VALUE cells:
<, >= should be
-
Greater/less than option
=IF(A2>=DATE(21,10,8),IF(A2 wrote:
> I've never tried it, but the ABS function on the Date Cell might also
> work.
>
> IF
I've never tried it, but the ABS function on the Date Cell might also
work.
IF (ABS(A2)=10/8/21,B2,"")
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
--
=IF(LEFT(A2,10)=("2021-10-08"),B2,"")
--
If you paste that formula into column E, you should have nulls where the
date does not match and the value in Column B where the date matches.
Note the above suggestion
On 2021/12/15 21:11, Hylton Conacher (ZR1HPC) wrote:
Hi,
I am quickly losing patience with a task that requires a sum of values
that occur on the same date, but at different times.
My raw data sheet is in 4 columns
Date/Time | Value 1| Value Y| Value z
2021-10-08 08:00:00| 5| 7| 0.15
ibreoffice-users] SUM, SUMIF, IF, INDEX,
MATCH, VLOOKUP?
Hi,
I am quickly losing patience with a task that requires a sum of values
that occur on the same date, but at different times.
My raw data sheet is in 4 columns
Date/Time | Value 1| Value Y| Value z
2021-10-08 08:00:00| 5| 7| 0.15
2021-10-0
On 2021/12/15 23:29, John Kaufmann wrote:
> On 2021-12-15 14:11, Hylton Conacher (ZR1HPC) wrote:
>> ...
>> I am quickly losing patience with a task that requires a sum of
values that occur on the same date, but at different times.
>>
>> My raw data sheet is in 4 columns [spaced for
Reply without the other stuff since this is somewhat long.
Wanted to try to create a macrothat would do everthing
with just the original data in columns A-D.
With old Quattro pro would have been amuch simpiler
process.. Would be nice if we could upload sheets.
Well, just wanted to see if I
Conacher (ZR1HPC)hyl...@conacher.co.za
Subject:=[libreoffice-users] SUM, SUMIF, IF, INDEX,
MATCH, VLOOKUP?
Hi,
I am quickly losing patience with a task that requires a sum of values
that occur on the same date, but at different times.
My raw data sheet is in 4 columns
Date/Time | Value 1
On 15 Dec 2021 at 21:11, Hylton Conacher (ZR1HPC)
wrote:
Date sent: Wed, 15 Dec 2021 21:11:55 +0200
To: LibreOffice Users
From: "Hylton Conacher (ZR1HPC)"
Subject: [libreoffice-users] SUM, SUMIF, IF, INDEX,
MATC
On 2021-12-15 14:11, Hylton Conacher (ZR1HPC) wrote:
...
I am quickly losing patience with a task that requires a sum of values that
occur on the same date, but at different times.
My raw data sheet is in 4 columns [spaced for comprehension]
Date/Time [stamp] | Value 1| Value Y| Value z
Hi,
I am quickly losing patience with a task that requires a sum of values
that occur on the same date, but at different times.
My raw data sheet is in 4 columns
Date/Time | Value 1| Value Y| Value z
2021-10-08 08:00:00| 5| 7| 0.15
2021-10-08 14:05:16| 3| 10| 5
2021-10-09 10:05:30| 15| 3| 25
12 matches
Mail list logo