How find running hours?

Help Studio
, ,
1

The image is a table showing hourly timestamps with corresponding start/stop status values of 0 or 1 for each hour on September 10, 2024. (Captioned by AI)
The image is a table showing hourly timestamps with corresponding start/stop status values of 0 or 1 for each hour on September 10, 2024. (Captioned by AI)368×674 4.76 KB

i need to find over all running hours, 0 is off, 1 is on calculate running time.

2

Hi, @domsmgtmeet22

You can use filter datatable activity
The image shows a Filter Wizard interface with parameters set to keep rows in the "Start/stop" column that contain the value "1". (Captioned by AI)

After, sum the hours

3

i need over all running hours example 4 hours,30 minutes this format

5
6

How can I found stop. For example first 1 digit start 9:24 . when it was stop ? is it 10:24. I saw total 10 hours

7

next 0 is stop for example.
1 on
1 on
1 on
0 off
1 on
1 on
0 off

9

IMHO, the presentation of the data is not good enough to reliably calculate running hours. For example, according to the data if it runs for 2 minutes - 10:23 to 10:25 - after the 9:24 check and before the 11:24 check, the calculation will show 2 hours running time!!!

10

Process data
1
1
0

The process will take the gap between the first 1 and second 1
It does not take the gap between 1 till the start of 0

If the data is
1
0
1

This code won’t work
cause the first 1 is the starting and the second one would be the end of that time
If the data is
0
0
1
1
1
0
It will still work

TimeSpanCheck.zip (78.3 KB)

11

out put is not showing you using two sequence which one is correct

12

Using Main sequence and the total time is stored in the variable TotalRunningTime
Just add a log message at the end with TotalRunningTime.ToString

13

@domsmgtmeet22

I want help to you. But I don’t understand. Please mark hours on the first image. How do you sum hours?

14

To calculate the overall running hours of an(AHU) based on the data.
“1” on time “0” is off time
i mentioned sample excel sheet for reference kindly share workflow for reference.

The image shows a spreadsheet with columns for "Hours" and "start/stop," indicating a timeline of hourly intervals on 09-10-2024 with binary values of 0 and 1 in the "start/stop" column. (Captioned by AI)
The image shows a spreadsheet with columns for "Hours" and "start/stop," indicating a timeline of hourly intervals on 09-10-2024 with binary values of 0 and 1 in the "start/stop" column. (Captioned by AI)323×672 4.78 KB

15

Is this topic different to the last one?

16

its not working kindly update the new one

17

People have asked you follow up questions regarding the “holes” in the data, for which I don’t see any clarification provided.
Maybe you can post screenshots of what you’ve tried already and point out which step you are facing difficulty at?

18

kindly share new work flow

19

@domsmgtmeet22 ,

I aggree to @sudster Please give secreenshoot