sunset

  1. B

    Categorizing time data into 15 minute periods.

    Hi! I have a large group of data which has number of bat calls (split by species) and then the time of each the calls. I would like to group the calls into 15 minute periods in relation to sunset eg 15 minutes before sunset, 0-15 minutes after sunset, 15-30 minutes after sunset, 30-45 mins...
  2. P

    calculate sunrise sunset based on coordinates

    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
  3. S

    Sun and Moon states

    Hi As you can see I'm a first time poster. I have spent the last 48 hours trying to find help on the below, suceeded in getting some way to the formula but seem to be falling at the last post! I have checked the forum, but can't find anything similar on which to compare. To give you some...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top