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
__________________________