I have a Mongodb collection of
Number Start_date End_date UserID
CHG123 25-09-2016 12:00:00 28-09-2016 13:00:00 userA
CHG456 25-09-2016 12:00:00 28-09-2016 13:00:00 userA
CHG789 25-09-2016 12:00:00 28-09-2016 13:00:00 userB
CHGabc 25-09-2016 12:00:00 28-09-2016 13:00:00 userA
What is the best way to spread time attribute if they are less than 3 mins apart, else do nothing. This is whether it is
start_date to start_date,
start_date to end_date,
end_start to end_date,
end_date to start_date
So that
CHG123 25-09-2016 12:00:00 28-09-2016 13:00:00 userA
CHG456 25-09-2016 12:03:00 28-09-2016 13:03:00 userA
CHG789 25-09-2016 12:06:00 28-09-2016 13:06:00 userB
CHGabc 25-09-2016 12:09:00 28-09-2016 13:09:00 userA