hi
i search a formula to check a period of time that some condition matched (same [name] but [old place] != [new place]), see example
[name] [date] [old place] [new place] [duration in same place per name]
bob 01/01 street street
bob 02/01 street office 1 day (01/01 till 02/01)
bill 02/01 street street
bob 03/01 office office
bill 04/01 street street
bill 05/01 street office 3 day (02/01 till 05/01)
bob 05/01 office office
bob 06/01 office street 4 day (02/01 till 06/01)
bill 06/01 office office
bill 07/01 office street 2 day (05/01 till 07/01)
