[SATLUG] Spread Sheet Formating
wmail at dslextreme.com
Tue Jan 13 11:20:10 CST 2015
In LibreOffice I found the [HH]:MM format code will do this. One of the
built-in time examples is [HH]:MM:SS, which I tried. It supports hours
above 24, and dropping the seconds display was obvious. Incidentally,
there's no rounding if you have part of a minute calculated - it just
truncates any leftover fractions of a minute. --Don
NATHAN OXHANDLER wrote:
>I am trying to create a spread sheet showing hours:min for a drive. Some of the drive times are longer then 24 hours. 32:26 26:14
>I cannot find a way to format an OO Calc cell to show those numbers, they keep subtracting 24 hours and show 8:26 2:14
>Anyone know how to overcome this?
Price slightly higher west of the Rockies.
More information about the SATLUG