For the following questions, the time is in E4.
------------------------------------------------------------------------------------------------
"Calculate the Dawn to Sunrise and Sunset to Dusk periods - from Local Time field (Column E)
(Dawn = 6:46, Dusk= 19:13, Sunrise = 7:13, Sunset= 17:24)"
The end result will read either 'dawn twilight' or 'dusk twilight'.
---------------------------------------------------------------------------------------------------
"Calculate the Sunrise to Sunset periods- from Local Time field
(Column E)
(Sunrise = 7:13, Sunset= 17:24)"
The end result will read 'day' or 'night'.
--------------------------------------------------------------------------------------------
"Calculate the Morning, Afternoon (based on daylight) and night time periods - from Local Time field (Column E)
(Sunrise = 7:13, Sunset= 17:24)"
The end result will be 'night', 'morning' or 'afternoon.
----------------------------------------------------------------------------------------------
All help is appreciated!
Bookmarks