Markus

Thanks for responding.

I'll have a look at this site when I return home in a few days time.

All the best.

Peter

"Markus L" wrote:

"Peter Barrett" wrote in message
...
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.

Take a look at
http://personal.inet.fi/cool/jjlammi/stuff.html

Markus