Put one event per row on the first worksheet, with these headings in the first row:
Other headings work too — you can match the columns in the next step.
Download the example workbook: the Albuquerque Balloon Fiesta, launched at first light and lit up again at dusk, and the solstice sunrise at Stonehenge. Import a sheet and view it in Albuquerque or Amesbury to see how much of each crowd came in golden hour.
Drag your Excel file here
Pick a place and see every sunrise, sunset and hour of daylight in it — drawn as one continuous image.