Am 26.02.2012 07:35, gldvorak wrote:
Using LibreOffice Calc I want to display the difference between two datetimes
as days and hours with correct rounding. I am having problems with the
rounding where for instance I get 2 days and 24 hours where the result
should be 3 days 0 hours.
Can someone help me?
--
View this message in context:
http://nabble.documentfoundation.org/Datetime-diff-formatting-tp3776477p3776477.html
Sent from the Users mailing list archive at Nabble.com.
=INT(A1) gives the number of days, cutting off any fractional part.
=MOD(A1;1) gives the fraction (the rest after dividing A1 by 1) which is
always smaller than 24:00.
Remove all number formatting from the day number.
Format the time number (fraction of day) as some time value.
As a text value in one cell:
=INT(A1)&" "&TEXT(MOD(A1;1);"HH:MM:SS")
[given that "HH:MM:SS" is a valid format string for your global locale
setting]
--
For unsubscribe instructions e-mail to: users+h...@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
