hello,
wonderful, the solution Michael D. Setzer II gave is amazing! Many thanks!
--
View this message in context:
http://nabble.documentfoundation.org/time-and-date-difference-tp4147099p4147109.html
Sent from the Users mailing list archive at Nabble.com.
--
To unsubscribe e-mail to:
Hello and thanks you all for the kind suggestions that helped me a lot..
I have found some points:
-first of all, I don't now why but I had to use . instead of : as
separator for time.. 15:30 won't be accepted while 15.30 is ok... this even
if cells were formatted as time maybe this is due to
Hello and thanks you all for the kind suggestions that helped me a lot..
I have found some points:
-first of all, I don't now why but I had to use . instead of : as
separator for time.. 15:30 won't be accepted while 15.30 is ok... this even
if cells were formatted as time maybe this is due to
Not sure if you want to just display the value as number as a message
B12 contains the later date - earlier date
=INT(B12/(60)) Hours INT(MOD(B12+0.0001,60)) Minutes
Creates This
48 Hours 50 Minutes
Had to add the 0.0001 otherwise was showing 49 minutes when int used.
On 24 Apr 2015 at 3:49,
hello everyone,
I am using LibreOffice Version: 4.3.0.4 and I am having issues calculating
time differences..
I would like to calculate the time difference in hours between the following
date/times:
E14 = 23/04/2015 15:30
E15 = 25/04/2015 16:20
E16 = DAYS(E15;E14)
But I get a value error so I
At 01:46 24/04/2015 -0700, Simone Serra wrote:
I am using LibreOffice Version: 4.3.0.4 and I am having issues
calculating time differences. I would like to calculate the time
difference in hours between the following
date/times:
E14 = 23/04/2015 15:30
E15 = 25/04/2015 16:20
E16 = DAYS(E15;E14)
Did the work below, but then came up with a simpler option.
Converts difference to minutes
=(E15-E14)/TIME(0,1,0)
Above Answer ANSWER/60
=((E15-E14)/TIME(0,1,0))/60
Above Answer INT(ANSWER/60) gives full hours
=INT(((E15-E14)/TIME(0,1,0))/60)
Above Answer MOD(ANSWR,60) gives minutes left
Am 24.04.2015 um 10:46 schrieb sserra:
hello everyone,
I am using LibreOffice Version: 4.3.0.4 and I am having issues calculating
time differences..
I would like to calculate the time difference in hours between the following
date/times:
E14 = 23/04/2015 15:30
E15 = 25/04/2015 16:20
Am 24.04.2015 um 10:46 schrieb sserra:
E14 = 23/04/2015 15:30
E15 = 25/04/2015 16:20
E16 = DAYS(E15;E14)
[...]
does anyone knows how can I solve this??
did you try
E16: =E15-E14
?
(IIRC set cell format to [hh] to display difference in hours)
Regards,
Nino
--
To unsubscribe e-mail to:
Am 24.04.2015 um 12:33 schrieb sserra:
Hello and thanks you all for the kind suggestions that helped me a lot..
I have found some points:
-first of all, I don't now why but I had to use . instead of : as
separator for time.. 15:30 won't be accepted while 15.30 is ok... this even
if cells
Try here: http://www.intel.com/support/graphics/sb/CS-034107.htm
On 4/23/2015 2:24 PM, Thomas Blasejewicz wrote:
On 2015/04/23 23:06, Paul D. Mirowsky wrote:
Screen tearing issue with NVidia may be resolved by changing Vertical
Sync to Adaptive.
Start video at URL below at 40 seconds.
Hi :)
Have you tried Gnumeric for spreadsheet work? It is a dedicated
spreadsheet program rather than being part of a suite so there are quite a
few advantages to it for serious spreadsheeting work.
Regards from
Tom :)
On 24 April 2015 at 08:39, yahoo-pier_andreit pier_andr...@yahoo.it wrote:
Am 24.04.2015 um 14:08 schrieb Tom Davies:
Hi :)
Have you tried Gnumeric for spreadsheet work? It is a dedicated
spreadsheet program rather than being part of a suite so there are quite a
few advantages to it for serious spreadsheeting work.
Regards from
Tom :)
Since Gnumeric is a
Hi Tom:
I've wanted to report it as a bug, but first I decided to ask the
community, in case I 'm the the origin of the failure .
Now I want to ask you how exactly can I report it to be treated as a bug by
the dev. community ?
Thanks.
(long live LibO!)
--
View this message in context:
m.a.riosv wrote:
I think Piet have pointed to the source of the problem.
Seems in several sheet there are cells formatted out data range. Sheet
'Análisis Pisos' seems empty but has a lot of empty comments, better delete
the sheet.
For a first cleaning, to do in every sheet:
-
Should Delete empty rows/columns be a new command on a sheet basis.
Sheet basis meaning you see the results of command before saving and can
undo.
I'm not sure it would be good a default unless the command would check
formulas to make sure empty cells are not referenced.
On 4/23/2015 7:57
One possibility comes to mind as to why empty cells are saved. If formatting
has been applied to the empty cells then they must be saved even if no values
are currently stored in those cells. As a trivial example consider the four
cell range A1:B2 which contain no values but the four cells are
Pete,
You still leave a lot unsaid such as whether the result is in a single fixed
location, what if anything is in the even numbered rows of column C, whether
any other column can be used for identification purposes, what if anything is
below the most recent month's data, etc. You imply that
2015-04-22 17:17 GMT+02:00 Thomas Blasejewicz ny...@hb.tp1.jp:
Good night = morning from Japan
I believe I did ask the same question in the past related to an
installation on a Win XP machine:
moving through documents (Writer) in LibreOffice while editing sometimes
(constantly!) sort of
Try importing into Base as csv, pay particular attention formatting on
this screen matches your csv.
During import keep an eye out for errors. Stop at error, look at last
record imported in table. Using text editor, fix that or next record.
Delete Base database and re-iterate until no errors
On 4/24/2015 4:46 AM, sserra simone.se...@cogne.com wrote:
hello everyone,
I am using LibreOffice Version: 4.3.0.4
Why? 4.3.6 is latest 4.3.x series...
It never amazes me the number of people who chase bugs using a dated
release - especially when it is the very first release in a major new
On 04/23/2015 08:53 PM, Luuk wrote:
On 23-4-2015 20:39, yahoo-pier_andreit wrote:
today I encountered a problem opening an excel file with libreoffice
4.3.something regarding maximum number of column, why number of columns
is so low in libreoffice ???
many thanks, ciao :-) pier
- Please,
At 21:00 24/04/2015 +0100, Pete Nikolic wrote:
I need to be able to select the last 3 in a series of cells that
change on a weekly basis so in
week 1: there would be 1 cell - no action
week 2: 2 cells - no action
week 3: 3 cells - sum three cells
week 4: 4 cells - sum last three
week 5: 5 cells
On Fri, 24 Apr 2015 21:52:47 +0100
Brian Barker b.m.bar...@btinternet.com wrote:
At 21:00 24/04/2015 +0100, Pete Nikolic wrote:
I need to be able to select the last 3 in a series of cells that
change on a weekly basis so in
week 1: there would be 1 cell - no action
week 2: 2 cells - no
Hi Folks ..
I need to be able to select the last 3 in a series of cells that change on a
weekly
basis
so i week 1 there would be 1 cell no action
week 2 2 cells no action
week 3 3 cell sum three cells
week 4
pete nikolic wrote:
Hi Folks ..
I need to be able to select the last 3 in a series of cells that change on
a weekly
basis
so i week 1 there would be 1 cell no action
week 2 2 cells no action
week 3 3
pete nikolic wrote:
if we start as will be the case C3 will contain say 50 (the actual
dates are
of little importance ) a month later C5 will be say 47 and so on every
month
the next cell would be C7 then C9 then C11 what i need is to be able to
automatically pick the
27 matches
Mail list logo