Hi michael, at first: Why do you answer to the list, some other persons and my private mail-address? I am reading and writing the the list and doens#T need the same message twice. >> >> I have tried it with German date-time-values and have set only >> =A2 - A1 >> ... and it returns 06:50:00 >> >> Regrads >> >> Robert > That would give difference in hours only, but would not give the days > This is cells L1-M7 Right of ___ is column M contents.
OK, need the day as a separate value: =ABRUNDEN(B1-A1)&":"&TEXT(B1-A1;"HH:MM") ABRUNDEN is the German Name for the function. Could be it is named FLOOR in the English version. HH:MM gives the hours and minutes without the days. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy