calculate sunrise sunset based on coordinates

[pjardino]

Hi,
Can anybody let me know how to calculate the sun rise sun set based on the coordinates of a location.
I have found a lot of online places but luck finding the formulas to calculate on a spreadsheet.

Help please.

Many thanks

Pjardino

 

[AlphaFrog]

Sunrise\Sunset equation
http://en.wikipedia.org/wiki/Sunrise_equation


An Excel workbook with VBA functions for sunrise, sunset, solar noon, twilight (dawn and dusk), and solar position (azimuth and elevation); by Greg Pelletier, translated from NOAA's online calculators for solar position and sunrise/sunset.
http://www.ecy.wa.gov/programs/eap/models/twilight.zip

 

[doctorman]

Sunrise\Sunset equation
Sunrise equation - Wikipedia


An Excel workbook with VBA functions for sunrise, sunset, solar noon, twilight (dawn and dusk), and solar position (azimuth and elevation); by Greg Pelletier, translated from NOAA's online calculators for solar position and sunrise/sunset.
http://www.ecy.wa.gov/programs/eap/models/twilight.zip

is there an updated version of that
it is based on an old calculation that is off by few minutes from 2005