{{InBedDateandTime}}|||=CONCATENATE(MID("{{InBedDateandTime}}",SEARCH(",","{{InBedDateandTime}}")+2,SEARCH("at","{{InBedDateandTime}}")-SEARCH(",","{{InBedDateandTime}}")-3),"-",TEXT(MONTH(DATEVALUE(LEFT("{{InBedDateandTime}}", SEARCH(" ","{{InBedDateandTime}}",1)-1)&" 1")),"00"),"-",TEXT(MID("{{InBedDateandTime}}",SEARCH(" ","{{InBedDateandTime}}")+1,SEARCH(",","{{InBedDateandTime}}")-SEARCH(" ","{{InBedDateandTime}}")-1),"00"),"T",TEXT(TIMEVALUE(SUBSTITUTE(SUBSTITUTE(RIGHT("{{InBedDateandTime}}",7),"PM"," PM",1),"AM"," AM",1)),"hh:mm:ss"))|||{{SleepDuration}}|||=VALUE((HOUR(TIME(LEFT("{{SleepDuration}}",2),MID("{{SleepDuration}}",4,2),RIGHT("{{SleepDuration}}",1)))*60*60)+(MINUTE(TIME(LEFT("{{SleepDuration}}",1),MID("{{SleepDuration}}",4,2),RIGHT("{{SleepDuration}}",1)))*60)+(SECOND(TIME(LEFT("{{SleepDuration}}",1),MID("{{SleepDuration}}",4,2),RIGHT("{{SleepDuration}}",1)))))||| {{TimeToSleep}}|||{{OutofBedDateandTime}}|||=CONCATENATE(MID("{{OutofBedDateandTime}}",SEARCH(",","{{OutofBedDateandTime}}")+2,SEARCH("at","{{OutofBedDateandTime}}")-SEARCH(",","{{OutofBedDateandTime}}")-3),"-",TEXT(MONTH(DATEVALUE(LEFT("{{OutofBedDateandTime}}", SEARCH(" ","{{OutofBedDateandTime}}",1)-1)&" 1")),"mm"),"-",TEXT(MID("{{OutofBedDateandTime}}",SEARCH(" ","{{OutofBedDateandTime}}")+1,SEARCH(",","{{OutofBedDateandTime}}")-SEARCH(" ","{{OutofBedDateandTime}}")-1),"dd"),"T",TEXT(TIMEVALUE(SUBSTITUTE(SUBSTITUTE(RIGHT("{{OutofBedDateandTime}}",7),"PM"," PM",1),"AM"," AM",1)),"hh:mm:ss"))|||{{DeviceUser}}|||{{TimeToGetUp}}|||{{LightSleepDuration}}|||{{DeepSleepDuration}}|||{{RemSleepDuration}}|||{{SleepScore}}|||{{StatusSleepScore}}|||{{StatusRecovery}}|||{{SnoringDuration}}|||{{SnoringEpisodesCount}}|||{{AwakeDuration}}|||{{HeartRateAverage}}|||{{StatusRegularity}}|||{{NbInterruptions}}