我想对json处理，得到另一种格式的json

[cyyjm]

原json：
[
{"user":"A","time":"2019.07.23","exactTime":"08:37,12:00,13:34,17:02"},
{"user":"A","time":"2019.07.24","exactTime":"08:40,12:00,13:33,17:03"},
{"user":"A","time":"2019.07.25","exactTime":"08:25,13:28,17:11"},
{"user":"A","time":"2019.07.26","exactTime":"08:20,17:14"},
{"user":"B","time":"2019.07.23","exactTime":"08:37,12:04,13:37"},
{"user":"B","time":"2019.07.24","exactTime":"12:03,13:28,17:04"},
{"user":"B","time":"2019.07.25","exactTime":"08:50,11:50,14:00"}
]

想得到这样的json格式
[
{"user":"A","time":"2019.07.23","Time1":"08:37","Time2":"12:00","Time3":"13:34","Time4":"17:02"},
{"user":"A","time":"2019.07.24","Time1":"08:40","Time2":"12:00","Time3":"13:33","Time4":"17:03"},
{"user":"A","time":"2019.07.25","Time1":"08:25","Time2":"","Time3":"13:28","Time4":"17:11"},
{"user":"A","time":"2019.07.26","Time1":"08:20","Time2":"","Time3":"","Time4":"17:14"},
{"user":"B","time":"2019.07.23","Time1":"08:37","Time2":"12:00","Time3":"13:34","Time4":"17:02"},
{"user":"B","time":"2019.07.24","Time1":"","Time2":"12:02","Time3":"13:28","Time4":"17:04"},
{"user":"B","time":"2019.07.25","Time1":"08:50","Time2":"11:50","Time3":"14:00","Time4":""}
]

[天际的海浪]

exactTime的时间不够4个的话，Time1，Time2，Time3，Time4中哪个为空？

[天际的海浪]

exactTime的时间不够4个的话，Time1，Time2，Time3，Time4中哪个为空？有什么规定？

[cyyjm]

看时间的格式，一般 08：xx 放到Time1,12：xx 放到 Time2,13：xx 放到 Time3,17：xx 放到 Time4

[天际的海浪]

var data = [
{"user":"A","time":"2019.07.23","exactTime":"08:37,12:00,13:34,17:02"},
{"user":"A","time":"2019.07.24","exactTime":"08:40,12:00,13:33,17:03"},
{"user":"A","time":"2019.07.25","exactTime":"08:25,13:28,17:11"},
{"user":"A","time":"2019.07.26","exactTime":"08:20,17:14"},
{"user":"B","time":"2019.07.23","exactTime":"08:37,12:04,13:37"},
{"user":"B","time":"2019.07.24","exactTime":"12:03,13:28,17:04"},
{"user":"B","time":"2019.07.25","exactTime":"08:50,11:50,14:00"}
];
data.forEach(function(obj){
	var arr = obj.exactTime.split(",");
	delete obj.exactTime;
	obj.Time1 = "";
	obj.Time2 = "";
	obj.Time3 = "";
	obj.Time4 = "";
	arr.forEach(function(v){
		var n = 1, h = parseInt(v, 10);
		if (h>8) n = 2;
		if (h>12) n = 3;
		if (h>16) n = 4;
		obj["Time"+n] = v;
	});
});
console.log(JSON.stringify(data,null,4));