[libreoffice-users] time and date difference

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 split data:

F14 = 23/04/2015
F15 = 25/04/2015
F16 = DAYS(F15;F14)  ---> Ok, I get 2, multiply  x 24 = 48h and it's fine

then for the hours

G14 = 15:30
G15 = 16:20
G16 = (G15<G14)+G15-G16 (as suggested by the wiki:
https://help.libreoffice.org/Calc/Calculating_Time_Differences)

but again I have a value error..

does anyone knows how can I solve this??



--
View this message in context: 
http://nabble.documentfoundation.org/time-and-date-difference-tp4147099.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted