Dear All
How can find the average time taken when I have hour, min and sec as diff variable
clear
input byte(hour_s min_s) double sec_s byte(hour_e min_e) double sec_e
10 35 0 10 52 0
7 30 0 7 51 0
4 40 0 5 7 0
5 55 0 5 54 0
6 22 0 6 32 0
4 37 0 4 58 0
4 20 0 4 45 0
4 17 0 4 34 0
5 31 59.999 5 47 0
6 22 0 6 30 0
5 28 0 5 43 0
10 30 0 10 46 59.999
4 20 0 4 36 0
5 13 0 5 29 0
6 4 0 6 24 59.999
9 56 0 10 20 0
6 51 0 7 0 0
6 8 0 6 23 0
6 16 59.999 6 50 0
11 14 0 . . .
4 23 0 4 6 0
5 28 0 5 59 0
5 47 59.999 5 57 0
10 58 0 11 8 0
3 49 0 4 1 0
6 20 0 6 34 0
10 36 0 10 43 0
9 14 0 9 30 0
4 38 59.999 4 54 0
4 5 0 4 35 0
4 57 0 5 26 0
9 53 0 10 13 0
4 34 0 4 54 59.999
4 53 0 5 33 0
4 20 0 4 33 0
9 23 0 9 29 0
6 15 0 6 39 0
3 40 59.999 4 1 59.999
5 42 0 5 58 0
5 38 0 5 51 0
10 53 0 11 12 0
6 5 0 5 51 0
6 36 0 6 42 0
4 50 0 5 9 0
11 54 0 12 7 0
8 35 0 8 55 0
9 37 0 9 53 0
4 22 0 4 46 59.999
5 42 0 5 49 0
4 52 0 5 2 59.999
13 1 0 12 46 0
10 9 59.999 10 30 0
3 40 59.999 4 0 0
10 16 0 10 44 0
10 1 59.999 10 17 0
8 57 0 9 22 0
3 23 0 2 9 0
5 10 59.999 5 19 0
9 18 0 9 45 0
3 46 0 3 58 0
5 8 0 5 29 0
11 57 0 12 6 0
9 57 0 10 8 0
6 24 59.999 6 40 0
8 27 0 8 39 0
4 5 0 4 14 0
5 30 0 5 42 0
3 32 0 3 26 0
10 54 0 11 38 0
4 54 0 5 10 0
4 27 0 4 40 0
9 4 0 8 41 0
5 39 59.999 5 47 0
4 33 0 4 58 0
9 39 0 10 11 0
4 34 0 4 56 0
4 17 59.999 4 31 0
9 32 0 9 56 0
4 30 0 4 53 0
8 29 0 8 50 0
5 2 0 5 21 0
5 39 59.999 5 54 0
5 44 0 6 0 0
5 18 0 5 44 0
5 21 0 5 35 0
6 42 0 6 58 0
5 20 0 5 36 0
10 48 0 10 56 0
3 53 59.999 4 17 59.999
4 38 59.999 5 1 0
10 56 0 11 2 59.999
3 47 0 3 53 0
5 4 0 5 20 0
9 58 0 10 6 0
8 57 0 9 5 0
4 0 0 4 15 0
3 53 59.999 4 16 0
6 40 59.999 6 58 0
4 38 59.999 4 51 0
9 49 0 10 23 0
end
Related Posts with Calculating avg time
GMM without lagged dependent variable using xtdpdgmmHello, I have a panel of large N and small T. Unbalanced and with time gaps. I hope to instrument th…
Marginal effects for standardized continuous variable in probit interactionI have a question that to my knowledge isn't addressed yet on this forum. I am running a probit reg…
Effect of time on culture positivityI have a data set of sample results (positive or negative) and want to look at the effect of collect…
Using bysort to Match Strings Across RowsThis is supposed to be easy but not sure why I am not getting it right (just a few months into Stata…
Creating a Custom YearA year ranges from January to December. However, I would like to create a custom fiscal year (FY) th…
Subscribe to:
Post Comments (Atom)
0 Response to Calculating avg time
Post a Comment