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!