Interval with multi dimensions

[AlbL]

Hey! Sruggling to get the time in between 2 indicators, for a given date.
See below example

Exisiting Fields	Exisiting Fields	Desired Field
TimeStamp	Status	Status Duration
01/02/20 2:43	ON	0.063877315
01/02/20 4:15	OFF	0.018321759
01/02/20 4:41	ON	0.035706019
01/02/20 5:33	OFF	0.008414352
01/02/20 5:45	ON	0.038310185
01/02/20 6:40	OFF	0.000671296
01/02/20 6:41	ON	0.043344907
01/02/20 7:43	OFF	0.033784722
01/02/20 8:32	ON	0.056840278
01/02/20 9:54	OFF	null	end of day
01/03/20 0:58	ON	0.583333333
01/03/20 14:58	OFF	null	end of day
01/04/20 1:51	ON	0.027650463
01/04/20 2:31	OFF	0.033113426
01/04/20 3:19	ON	0.02587963
01/04/20 3:56	OFF	0.039872685
01/04/20 4:53	ON	0.016909722
01/04/20 5:18	OFF	0.022835648
01/04/20 5:51	ON	0.052881944
01/04/20 7:07	OFF	0.015856481
01/04/20 7:30	ON	0.105810185
01/04/20 10:02	OFF	null	end of day

Any ideas how i could achieve that? Ultimately I will then sum the values on ON and OFF for each day. 

Thanks very much!