Re: [libreoffice-users] Calculate difference between two dates (with time)

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+unsubscribe@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