Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello.
Nursemaiding required for a perpetual lamer please. I want to put this stuff on an XL sheet or in another producer's spreadsheet if it will be easier. I wish to move the date over to the other side of the month and put the hour column in its own cells separate from the minutes as I wish to divide the hour (by 6) without touching the minutes. It must be a simple process I suppose but I wouldn't know where to start. Thank you in advance etc., etc.. http://aa.usno.navy.mil/cgi-bin/aa_m...s.pl?year=2006 2006 Phases of the Moon Universal Time 00000 New Moon 000 First Quarter 000 Full Moon 000 Last Quarter 00000000 d h m 0000000 d h m 0000000 d h m 000000 d h m 0000000000000000 Jan 6 18 56 Jan 14 9 48 Jan 22 15 14 Jan 29 14 15 Feb 5 6 29 Feb 13 4 44 Feb 21 7 17 Feb 28 0 31 Mar 6 20 16 Mar 14 23 35 Mar 22 19 10 Mar 29 10 15 Apr 5 12 01 Apr 13 16 40 Apr 21 3 28 Apr 27 19 44 May 5 5 13 May 13 6 51 May 20 9 21 May 27 5 26 Jun 3 23 06 Jun 11 18 03 Jun 18 14 08 Jun 25 16 05 Jul 3 16 37 Jul 11 3 02 Jul 17 19 13 Jul 25 4 31 Aug 2 8 46 Aug 9 10 54 Aug 16 1 51 Aug 23 19 10 Aug 31 22 56 Sep 7 18 42 Sep 14 11 15 Sep 22 11 45 Sep 30 11 04 Oct 7 3 13 Oct 14 0 26 Oct 22 5 14 Oct 29 21 25 Nov 5 12 58 Nov 12 17 45 Nov 20 22 18 Nov 28 6 29 Dec 5 0 25 Dec 12 14 32 Dec 20 14 01 Dec 27 14 48 The zeros in the legends are for spacing over usenet. I'm not bothered about the legends but it would be nice to keep the phases in sequence. (It's no big deal though.) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Text to Columns / Importing Data | Excel Discussion (Misc queries) | |||
importing multiple text files URGENT!!! HELP | Excel Worksheet Functions | |||
importing multiple text files??? | Excel Discussion (Misc queries) |