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
-nbvargr- download fails, Stata 12Stata Version: 12 Dear all, I've tried to download the user written command -nbvargr-, however I r…
drop duplicates valuesHello, I want to drop duplicates values of a variable if the number of copies are less than five. T…
merge two files.Dear All, I find this question here (in Chinese). There are two files. The first one is something li…
Time dummies to estimate the length of relationshipsI am working with 18 waves of panel data (HILDA) and in each wave, respondents state their marital s…
When I double-click a .dta file, Stata recognizes it as an R file! How to fix it?Today, I went to work on Stata and double clicked a .dta file. The computer presented the message b…
Subscribe to:
Post Comments (Atom)
0 Response to Calculating avg time
Post a Comment