[libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?

Am 16.07.2015 um 18:49 schrieb tonybsa:
> The secret i using the Edit > Fill > Series menu options
>
> So now you have the dates, with days in the A column you could put time along the the row 1. 
> Starting at B1 and use the Edit > Fill > Series >Right > Date . Start 08:00, End 12:00 Increment 
> 1:00.
> Just ensure that the Cell Format for the Row is set to Time rather than Date.
>
> Hope this helps.

This topic as started by Gilles is about dates. Dragging down a single
number (currency, date, time, whatever) increases the value by one which
is one day.
Problem is that too many spreadsheet users do not know what a
spreadsheet date/time is and how it differs from a text such as
"16/07/2015" which is not a date by any means.

For intervals other than one day you can use the fill-series dialog _or_
enter 2 start values (e.g. 8:00 and 9:00), select the two values and
drag down the interval.


-- 
To unsubscribe e-mail to: users+unsubscribe@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