Use Edit > Fill > Series
Click in cell A2
Right click Format Cells > date > Fri, 31Dec 99 > OK
With A2 still selected shift click A6
When the dialog box opens
Select Down > Date > Day
Enter start date: 3/08/2015
Enter finish date: 7/08/2015
Mon, 3 Aug 15
Tue, 4 Aug 15
Wed, 5 Aug 15
Thu, 6 Aug 15
Fri, 7 Aug 15
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
Just ensure that the Cell Format for the Row is set to Time rather than Date.
Hope this helps.
"I came into this world with nothing.
Fortunately I have got most of it left."
To unsubscribe e-mail to: email@example.com
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
Re: [libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)? · John & Ruth Sparrow
[libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)? · Andreas Säger
- Re: [libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)? (continued)
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy