Should be able to use recurring event individual items' fields (e.g. start time, end time) in calculated column
Currently, if you use a recurring event's field like Start time in calculated column, it is using the main event's start time so it is treated as 1 item. In other word, Start time = Start time of the first event and End time = End time of the last event. We want to be able to use the start time of the individual item created by the recurring event instead.
Context: We have a SharePoint Online calendar list that people are using as a sign up sheet. What we want to do is to create a simple view that shows the number of people in the office every day grouped by department (field). The challenge is most people created recurring items and what we found is recurring items start date/time is actually the start date/time of the first item and the end date/time is the end date/time of the last item. What we want is to have the individual Calendar items start and end time (broken by days). There is no way to do this at this point.