Hi! I recently edited an Excel spreadsheet in LibreOffice Calc 7.2.4.1
on Windows 10 and after saving the updated XLSX file, I imported it into
Office 365 Excel online (the free version available if you have a
Hotmail account) and noticed the "print friendly" PDF version reported
having 188
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