Richard

That is indeed very helpful.

I am now trying to figure out if (and how) it is possible to use the
functions created in the spreadsheet on the website in my own spreadsheet so
that I can generate sunrise and sunset times for specific locations on
specific days. Any advice?

PS - if you happen to be interested in these things, I also came across a
useful program at http://www.fv01.dial.pipex.com/world.htm?suntimes.shtml

All the best.

Peter

"Richard Buttrey" wrote:

On Wed, 7 Sep 2005 10:10:07 -0700, "Peter Barrett"
wrote:

Does anybody know of a function / add-in / piece of programming that will
generate the sunrise and sunset times for a location based on it's latitude
and longitude and the date.

I know there are tables on the intenet - but I would like to generate the
data within my worksheet - rather than copy data from the internet and spend
ages formatting it.

Worth a try!

All the best.


Try

http://www.ecy.wa.gov/programs/eap/models/

The 6th item down is an Excel Sunrise/Sunset calculator.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________