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+unsubscr...@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