Separate time stamp and payload from string

Welcome! Your device is sending not so “well” formatted messages but never mind.

You can use a function node using the string.split() function and take your string appart:

var parts=msg.payload.split(“:”);
msg.timeString=parts[0]+”:”+parts[1]+”:”+parts [2];
msg.payload=Number(parts[3]);
msg.timestamp= new Date();
msg.timestamp=msg.timestamp.setHours(Number(parts[0]), Number(parts[1]), Number(parts[2])).valueOf();
return msg;

Code not tested just typed in on my phone but give it a try.