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: [email protected] 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
