I want to find the daytime and night-time occurrence duration of an event from its' start time to end time. The event duration is volatile and can take place for a long time. I can't figure out a formula. I am seeking to figure out the duration with a formula or VBA code or Python code. Link to the sample file with manually calculated duration for each event. The event occurs in multiple scenarios to be considered. Continue reading...
