[libreoffice-users] Re: Datetime diff formatting

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