I have set of data that have start datetime and end datetime, from this set of data I want to split the data in to two if the month of the two date is overlapping, then calculate duration based on month
ExampleThis is my set of data
and the result should be like this
Can this be done automatically using formula expressions, I already do it manually, splitting the data one by one then calculate the duration
New contributor
Muhammad Syukri Mansor is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.