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

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

Result:
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 
1:00.
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
tonybsa@me.com




-- 
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