Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel
external usenet poster
 
Posts: 331
Default Transposing Sun and Moon rise and set times...

Hello,

I have data that represents, rise and set times for the sun and moon
over a time span of 12 months. Data for each consecutive month appear
in joining columns as follows:

January February
Day Sun_Rise Sun_Set Moon_Rise Moon_Set Sun_Rise Sun_Set Moon_Rise
Moon_Set
1 0700 1625 1400 0255 0705 1710 0901 2114
2 0701 1625 1429 0413 0704 1711 0924 2229
3 0702 1625 1504 0532 0703 1713 0947 2343
4 0703 1625 1548 0650 0702 1714 1013
5 0704 1625 1642 0803 0701 1715 1042 0056
6 0705 1625 1745 0905 0700 1716 1117 0207
7 0706 1625 1854 0955 0659 1718 1159 0315
8 0707 1624 2003 1034 0657 1719 1249 0416
9 0708 1625 2110 1104 0656 1720 1346 0509
10 0708 1625 2214 1129 0655 1721 1448 0552
11 0709 1625 2316 1150 0654 1723 1552 0627
12 0710 1625 1209 0652 1724 1655 0656
13 0711 1625 0016 1227 0651 1725 1758 0720
14 0712 1625 0116 1246 0650 1726 1859 0740
15 0712 1625 0217 1306 0649 1728 1959 0759
16 0713 1626 0320 1329 0647 1729 2100 0817
17 0714 1626 0426 1358 0646 1730 2202 0836
18 0714 1626 0533 1433 0645 1731 2306 0856
19 0715 1627 0640 1518 0643 1733 0919
20 0715 1627 0742 1614 0642 1734 0013 0947
21 0716 1628 0836 1721 0640 1735 0122 1023
22 0716 1628 0921 1834 0639 1736 0232 1109
23 0717 1629 0957 1949 0637 1737 0338 1208
24 0717 1629 1027 2104 0636 1739 0436 1320
25 0718 1630 1053 2218 0634 1740 0523 1440
26 0718 1631 1116 2331 0633 1741 0601 1603
27 0718 1631 1139 0631 1742 0632 1726
28 0719 1632 1202 0044 0630 1743 0659 1846
29 0719 1633 1229 0158
30 0719 1634 1300 0315
31 0719 1634 1339 0431

Does Excel have a way to convert this data into calendar? Or perhaps
someone can explain how best to transpose this data so that it can be
used in a calendar template for mail merge?

Thanks in advance for your responses.

-Greg
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rise over Run Formula Cindy at PWIC Charts and Charting in Excel 2 March 28th 09 12:11 AM
Transposing Sun and Moon rise and set times... [email protected] Excel Discussion (Misc queries) 4 September 22nd 05 04:20 PM
Transposing Sun and Moon rise and set times... [email protected] Excel Worksheet Functions 4 September 22nd 05 04:20 PM
Transposing Sun and Moon rise and set times... Greg Excel Discussion (Misc queries) 0 September 19th 05 08:05 PM
Transposing Sun and Moon rise and set times... Greg Excel Worksheet Functions 0 September 19th 05 08:05 PM


All times are GMT +1. The time now is 12:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"