1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL

  • A matter of Time overlap calculations

    From Greg Della-Croce@21:1/5 to All on Mon Jul 6 11:43:24 2020
    I have a database of events it has a starting date/time in the format: Monday9:00AM

    the duration is in the format:
    2hr

    I need to create a report of all events to show which event overlaps other events.

    Monday
    8:00AM EVENT2
    9:00AM EVENT1 |
    10:00AM | |
    11:00AM EVENT3
    12:00PM |
    1:00PM |

    So if a person goes to Event2 they can not attend Event1 but can attend Event3.

    Eventually, I want to pull the data in, have a person see all the events, then when the pick one the overlapping events are removed from the list.

    Any ideas for how to do this first step of the process?

    Thanks!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From James Marks@21:1/5 to gdcro...@gmail.com on Tue Feb 2 18:01:31 2021
    On Monday, July 6, 2020 at 10:43:27 AM UTC-8, gdcro...@gmail.com wrote:
    I have a database of events it has a starting date/time in the format: Monday9:00AM

    the duration is in the format:
    2hr

    I need to create a report of all events to show which event overlaps other events.

    Monday
    8:00AM EVENT2
    9:00AM EVENT1 |
    10:00AM | |
    11:00AM EVENT3
    12:00PM |
    1:00PM |

    So if a person goes to Event2 they can not attend Event1 but can attend Event3.

    Eventually, I want to pull the data in, have a person see all the events, then when the pick one the overlapping events are removed from the list.

    Any ideas for how to do this first step of the process?

    Thanks!
    I guese do nothing

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Thibaud Taudin Chabot@21:1/5 to All on Wed Feb 3 11:52:34 2021
    Op 3-2-2021 om 03:01 schreef James Marks:
    On Monday, July 6, 2020 at 10:43:27 AM UTC-8, gdcro...@gmail.com wrote:
    I have a database of events it has a starting date/time in the format:
    Monday9:00AM

    the duration is in the format:
    2hr

    I need to create a report of all events to show which event overlaps other events.

    Monday
    8:00AM EVENT2
    9:00AM EVENT1 |
    10:00AM | |
    11:00AM EVENT3
    12:00PM |
    1:00PM |

    So if a person goes to Event2 they can not attend Event1 but can attend Event3.

    Eventually, I want to pull the data in, have a person see all the events, then when the pick one the overlapping events are removed from the list.

    Any ideas for how to do this first step of the process?

    Thanks!
    I guese do nothing

    Substract. If difference <= (2/24) there is an overlap

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Zaidy036@21:1/5 to Greg Della-Croce on Wed Feb 3 15:21:55 2021
    On 7/6/2020 2:43 PM, Greg Della-Croce wrote:
    I have a database of events it has a starting date/time in the format: Monday9:00AM

    the duration is in the format:
    2hr

    I need to create a report of all events to show which event overlaps other events.

    Monday
    8:00AM EVENT2
    9:00AM EVENT1 |
    10:00AM | |
    11:00AM EVENT3
    12:00PM |
    1:00PM |

    So if a person goes to Event2 they can not attend Event1 but can attend Event3.

    Eventually, I want to pull the data in, have a person see all the events, then when the pick one the overlapping events are removed from the list.

    Any ideas for how to do this first step of the process?

    Thanks!

    What you want is "Project Scheduling" formal name "Gantt Chart"

    Do a Google search 'project schedule excel'

    One free template is at <https://www.vertex42.com/ExcelTemplates/project-schedule-template.html>

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)