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 were formatted as time maybe this is due to my regional settings >
You are working with an Italian locale. Tools>Options>LanguageSettings>Languages = Italian(Italy) > -for the circular reference mentioned by Brian Barker it was a mistake > copying the formula from the sheet to the webpage.. sorry for this.. Anyway, > changing the separator works fine > > -when I have: > E14: 23/04/15 15.30 > E15: 25/04/15 16.20 > > both E16: =E15-E14 and E16 = DAYS(E15;E14) give the integer number 2.0 but > using the first formula and changing format to hours and back to numbers I > have 2.034 that should be correct.. > > thanks again! > > The cell value remains 2 (days) displayed as 48:00 (hours). If you want to calculate with hours, multiply the day value by 24. > > > -- > View this message in context: > http://nabble.documentfoundation.org/time-and-date-difference-tp4147099p4147106.html > Sent from the Users mailing list archive at Nabble.com. > -- To unsubscribe e-mail to: [email protected] 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
