At 22:35 25/02/2012 -0800, G L Dvorak 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.
Something like this?
=INT(ROUND((B1-A1)*24)/24)&":"&MOD(ROUND((B1-A1)*24);24)
I trust this helps.
Brian Barker
--
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
