calculate sunrise sunset based on coordinates

pjardino

New Member
Joined
Aug 9, 2005
Messages
3
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
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,102,303
Messages
5,486,061
Members
407,530
Latest member
Shameem Khan

This Week's Hot Topics

Top