[SATLUG] Spread Sheet Formating

NATHAN OXHANDLER nathan at gvtc.com
Tue Jan 13 14:34:31 CST 2015


Don,

Thanks, it does work for what is displayed which will do for now.

Nathan

----- Original Message -----
> From: "Don Wright" <wmail at dslextreme.com>
> To: "The San Antonio Linux User's Group Mailing List" <satlug at satlug.org>
> Sent: Tuesday, January 13, 2015 11:20:10 AM
> Subject: Re: [SATLUG] Spread Sheet Formating
> 
> 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?
> >
> >Nathan
> 
> --
> Price slightly higher west of the Rockies.
> --
> _______________________________________________
> SATLUG mailing list
> SATLUG at satlug.org
> http://alamo.satlug.org/mailman/listinfo/satlug to manage/unsubscribe
> Powered by Rackspace (www.rackspace.com)
> 


More information about the SATLUG mailing list