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