[libreoffice-users] Re: time and date difference

2015-04-24 Thread sserra
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: users+un

[libreoffice-users] Re: time and date difference

2015-04-24 Thread 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 were formatted as time maybe this is due t

[libreoffice-users] Re: time and date difference

2015-04-24 Thread 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 were formatted as time maybe this is due t

[libreoffice-users] time and date difference

2015-04-24 Thread 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 E16 = DAYS(E15;E14) But I get a value error so I sp