Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

Use Edit > Fill > Series 

Click in cell A2
Right click Format Cells > date > Fri, 31Dec 99 > OK
With A2 still selected shift click A6
Click Edit>Fill>Series
When the dialog box opens
Select Down > Date > Day
Enter start date:  3/08/2015
Enter finish date: 7/08/2015
Increment: 1
Click OK

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."
Tony Bray

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.