Re: Time representation in Writer

Bruce Lloyd wrote:
>   I was making a timetable in a *table *in a document in Writer and
> having trouble getting time to show properly and wonder if there is a
> way to change the configuration. The problem is when I want to write a
> time as '8.30' Writer automatically truncates it to '8.3' if I use a
> colon then Writer automatically makes it 8:30:00 (or was it 08:30:00)
> which is equally unsatisfactory. The only way I could overcome the
> problem was make the time '8.31' or use a comma '8,30'. If I needed
> '8.00' it ended up as '8' unless I wrote it as '8,00'
>
> I can't see why Writer bothers with such things as removing a zero from
> the end of a decimal and presumably the problem/solution is in table
> properties or Auto Correct or Auto Complete but I could not find it. It
> doesn't seem to happen when 8.00 is written in text just in a table. Is
> there something I can change?
>
> regards
> Bruce

Tables in Writer behave as a simple spreadsheet - you can control 
formatting of numbers, dates, times, etc., and can use basic formulas. 
They're not as powerful as Calc spreadsheets, but allow you to do the 
basics within a Writer document without having to embed a spreadsheet.

Select the cells you want to format, then go to the Table menu > Number 
Format and choose the format you want. e.g. you can display times as 
08:30 rather than 08:30:00, or if you don't want the leading zero either 
enter "H:MM" for the format code rather than "HH:MM" (it will still 
display two digits if required).

Hope that helps.
Mark.

-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help