Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
  • #1

    How to convert minutes into hours

    Hello!

    I have a variable labeled as "minutes" that calculates the total time a patient was in an appointment. I would like to generate a new variable that converts the minutes into hours (e.g., 30 minutes --> 0.5 hours; 90 minutes --> 1.5 hours, etc.). Any help would be greatly appreciated!

    Code:
    * Example generated by -dataex-. For more info, type help dataex
clear
input double minutes str22 appt_desc str20 appt_cat
 29.99999999825377 "Scheduled"             "Successful"
 29.99999999825377 "Unscheduled / Walk-In" "Successful"
                45 "Unscheduled / Walk-In" "Successful"
                90 "Scheduled"             "Successful"
 60.00000000174623 "Scheduled"             "Successful"
 74.99999999825377 "Unscheduled / Walk-In" "Successful"
 39.99999999941792 "Scheduled"             "Successful"
 34.99999999883585 "Unscheduled / Walk-In" "Successful"
 60.00000000174623 "Scheduled"             "Successful"
                90 "Unscheduled / Walk-In" "Successful"
10.000000001164153 "Scheduled"             "Successful"
                45 "Unscheduled / Walk-In" "Successful"
 29.99999999825377 "Scheduled"             "Successful"
                45 "Scheduled"             "Successful"
 34.99999999883585 "Scheduled"             "Successful"
20.000000002328306 "Scheduled"             "Successful"
 15.00000000174623 "Unscheduled / Walk-In" "Successful"
100.00000000116415 "Scheduled"             "Successful"
 39.99999999941792 "Unscheduled / Walk-In" "Successful"
                45 "Scheduled"             "Successful"
 15.00000000174623 "Scheduled"             "Successful"
 60.00000000174623 "Scheduled"             "Successful"
 60.00000000174623 "Scheduled"             "Successful"
                90 "Scheduled"             "Successful"
                90 "Scheduled"             "Successful"
10.000000001164153 "Scheduled"             "Successful"
 15.00000000174623 "Scheduled"             "Successful"
240.00000000174623 "Scheduled"             "Successful"
119.99999999825377 "Scheduled"             "Successful"
 39.99999999941792 "Unscheduled / Walk-In" "Successful"
 29.99999999825377 "Unscheduled / Walk-In" "Successful"
                 0 "Scheduled"             "Successful"
                45 "Unscheduled / Walk-In" "Successful"
100.00000000116415 "Scheduled"             "Successful"
                45 "Scheduled"             "Successful"
 29.99999999825377 "Unscheduled / Walk-In" "Successful"
 5.000000000582077 "Scheduled"             "Successful"
                90 "Scheduled"             "Successful"
                90 "Scheduled"             "Successful"
 60.00000000174623 "Scheduled"             "Successful"
 29.99999999825377 "Unscheduled / Walk-In" "Successful"
 60.00000000174623 "Scheduled"             "Successful"
                90 "Scheduled"             "Successful"
10.000000001164153 "Unscheduled / Walk-In" "Successful"
 29.99999999825377 "Scheduled"             "Successful"
 29.99999999825377 "Scheduled"             "Successful"
                90 "Scheduled"             "Successful"
 29.99999999825377 "Unscheduled / Walk-In" "Successful"
 60.00000000174623 "Scheduled"             "Successful"
                45 "Unscheduled / Walk-In" "Successful"
                90 "Unscheduled / Walk-In" "Successful"
 60.00000000174623 "Scheduled"             "Successful"
195.00000000174623 "Scheduled"             "Successful"
 74.99999999825377 "Scheduled"             "Successful"
 29.99999999825377 "Scheduled"             "Successful"
20.000000002328306 "Scheduled"             "Successful"
                90 "Scheduled"             "Successful"
 39.99999999941792 "Unscheduled / Walk-In" "Successful"
 29.99999999825377 "Scheduled"             "Successful"
119.99999999825377 "Unscheduled / Walk-In" "Successful"
209.99999999825377 "Scheduled"             "Successful"
 29.99999999825377 "Scheduled"             "Successful"
 29.99999999825377 "Scheduled"             "Successful"
 5.000000000582077 "Scheduled"             "Successful"
 39.99999999941792 "Scheduled"             "Successful"
 60.00000000174623 "Scheduled"             "Successful"
                90 "Scheduled"             "Successful"
 50.00000000058208 "Scheduled"             "Successful"
 5.000000000582077 "Unscheduled / Walk-In" "Successful"
 29.99999999825377 "Scheduled"             "Successful"
10.000000001164153 "Unscheduled / Walk-In" "Successful"
 39.99999999941792 "Scheduled"             "Successful"
 60.00000000174623 "Scheduled"             "Successful"
 29.99999999825377 "Scheduled"             "Successful"
                45 "Scheduled"             "Successful"
 29.99999999825377 "Scheduled"             "Successful"
 29.99999999825377 "Unscheduled / Walk-In" "Successful"
119.99999999825377 "Scheduled"             "Successful"
105.00000000174623 "Unscheduled / Walk-In" "Successful"
 60.00000000174623 "Scheduled"             "Successful"
140.00000000058208 "Scheduled"             "Successful"
 29.99999999825377 "Scheduled"             "Successful"
 60.00000000174623 "Scheduled"             "Successful"
 15.00000000174623 "Scheduled"             "Successful"
119.99999999825377 "Scheduled"             "Successful"
119.99999999825377 "Scheduled"             "Successful"
 55.00000000116415 "Scheduled"             "Successful"
 29.99999999825377 "Scheduled"             "Successful"
 29.99999999825377 "Scheduled"             "Successful"
                90 "Scheduled"             "Successful"
                45 "Scheduled"             "Successful"
                90 "Unscheduled / Walk-In" "Successful"
                45 "Scheduled"             "Successful"
                 0 "Scheduled"             "Successful"
 29.99999999825377 "Scheduled"             "Successful"
                90 "Scheduled"             "Successful"
 29.99999999825377 "Unscheduled / Walk-In" "Successful"
119.99999999825377 "Unscheduled / Walk-In" "Successful"
 15.00000000174623 "Scheduled"             "Successful"
               180 "Scheduled"             "Successful"
end
    Tags: None
  • #2
    I'm worried that I'm missing something but isn't the following what you want:
    Code:
    gen hours=minutes/60
    • 1 like

    Comment

    • #3
      I would divide by 60. Nothing recondite about dates or times is needed here; it's just the standard calculation you think it is.

      That said, your minutes variable has many puzzling near-integers, so it would be interesting to know what is upstream. But if you force them to integers first, you will still have a precision problem as e.g. 10 20 40 50 minutes / 1 hour don't have exact binary equivalent.

      Comment

      • #4
        Thank you Nick and Rich! I had attempted to generate the "minutes" variable on my own, but using the original "client_hrs" variable I was able to get what I was looking for using: gen appthours=hh(client_hrs)+mm(client_hrs)/60. This was my result:

        Code:
        * Example generated by -dataex-. For more info, type help dataex
clear
input double client_hrs str22 appt_desc str20 appt_cat float appthours
     -1.8934524e+12 "Scheduled"             "Successful"         1
     -1.8934542e+12 "Unscheduled / Walk-In" "Successful"        .5
     -1.8934533e+12 "Unscheduled / Walk-In" "Successful"       .75
     -1.8934542e+12 "Scheduled"             "Successful"        .5
     -1.8934524e+12 "Scheduled"             "Successful"         1
      -1.893456e+12 "Scheduled"             "Successful"         0
     -1.8934542e+12 "Scheduled"             "Successful"        .5
     -1.8934533e+12 "Unscheduled / Walk-In" "Successful"       .75
     -1.8934524e+12 "Unscheduled / Walk-In" "Successful"         1
       -1.89345e+12 "Scheduled"             "Successful" 1.6666666
     -1.8934554e+12 "Scheduled"             "Successful" .16666667
     -1.8934542e+12 "Scheduled"             "Successful"        .5
     -1.8934542e+12 "Scheduled"             "Successful"        .5
     -1.8934533e+12 "Scheduled"             "Successful"       .75
     -1.8934488e+12 "Scheduled"             "Successful"         2
     -1.8934551e+12 "Unscheduled / Walk-In" "Successful"       .25
     -1.8934551e+12 "Unscheduled / Walk-In" "Successful"       .25
     -1.8934506e+12 "Scheduled"             "Successful"       1.5
     -1.8934536e+12 "Unscheduled / Walk-In" "Successful"  .6666667
     -1.8934533e+12 "Scheduled"             "Successful"       .75
     -1.8934542e+12 "Unscheduled / Walk-In" "Successful"        .5
     -1.8934524e+12 "Scheduled"             "Successful"         1
     -1.8934524e+12 "Scheduled"             "Successful"         1
     -1.8934524e+12 "Scheduled"             "Successful"         1
     -1.8934533e+12 "Scheduled"             "Successful"       .75
-1893454500000.0002 "Scheduled"             "Successful"        .4
     -1.8934551e+12 "Scheduled"             "Successful"       .25
     -1.8934488e+12 "Scheduled"             "Successful"         2
      -1.893447e+12 "Unscheduled / Walk-In" "Successful"       2.5
     -1.8934542e+12 "Scheduled"             "Successful"        .5
     -1.8934542e+12 "Unscheduled / Walk-In" "Successful"        .5
      -1.893456e+12 "Scheduled"             "Successful"         0
     -1.8934536e+12 "Unscheduled / Walk-In" "Successful"  .6666667
       -1.89345e+12 "Scheduled"             "Successful" 1.6666666
     -1.8934542e+12 "Unscheduled / Walk-In" "Successful"        .5
     -1.8934542e+12 "Scheduled"             "Successful"        .5
     -1.8934524e+12 "Scheduled"             "Successful"         1
     -1.8934524e+12 "Scheduled"             "Successful"         1
     -1.8934506e+12 "Scheduled"             "Successful"       1.5
     -1.8934524e+12 "Unscheduled / Walk-In" "Successful"         1
     -1.8934488e+12 "Scheduled"             "Successful"         2
     -1.8934542e+12 "Scheduled"             "Successful"        .5
     -1.8934506e+12 "Scheduled"             "Successful"       1.5
     -1.8934533e+12 "Scheduled"             "Successful"       .75
-1893454799999.9998 "Scheduled"             "Successful"  .3333333
     -1.8934506e+12 "Unscheduled / Walk-In" "Successful"       1.5
     -1.8934434e+12 "Scheduled"             "Successful"       3.5
     -1.8934542e+12 "Unscheduled / Walk-In" "Successful"        .5
     -1.8934524e+12 "Scheduled"             "Successful"         1
      -1.893456e+12 "Scheduled"             "Successful"         0
     -1.8934524e+12 "Scheduled"             "Successful"         1
     -1.8934524e+12 "Scheduled"             "Successful"         1
     -1.8934452e+12 "Scheduled"             "Successful"         3
     -1.8934524e+12 "Scheduled"             "Successful"         1
     -1.8934542e+12 "Scheduled"             "Successful"        .5
     -1.8934524e+12 "Scheduled"             "Successful"         1
     -1.8934506e+12 "Scheduled"             "Successful"       1.5
     -1.8934536e+12 "Scheduled"             "Successful"  .6666667
     -1.8934524e+12 "Scheduled"             "Successful"         1
     -1.8934488e+12 "Unscheduled / Walk-In" "Successful"         2
     -1.8934488e+12 "Scheduled"             "Successful"         2
     -1.8934542e+12 "Scheduled"             "Successful"        .5
     -1.8934542e+12 "Scheduled"             "Successful"        .5
     -1.8934506e+12 "Scheduled"             "Successful"       1.5
     -1.8934524e+12 "Unscheduled / Walk-In" "Successful"         1
-1893454799999.9998 "Scheduled"             "Successful"  .3333333
     -1.8934506e+12 "Scheduled"             "Successful"       1.5
     -1.8934542e+12 "Unscheduled / Walk-In" "Successful"        .5
     -1.8934524e+12 "Unscheduled / Walk-In" "Successful"         1
     -1.8934488e+12 "Unscheduled / Walk-In" "Successful"         2
     -1.8934554e+12 "Unscheduled / Walk-In" "Successful" .16666667
     -1.8934515e+12 "Scheduled"             "Successful"      1.25
     -1.8934524e+12 "Scheduled"             "Successful"         1
     -1.8934542e+12 "Scheduled"             "Successful"        .5
     -1.8934488e+12 "Unscheduled / Walk-In" "Successful"         2
     -1.8934506e+12 "Scheduled"             "Successful"       1.5
     -1.8934506e+12 "Scheduled"             "Successful"       1.5
     -1.8934551e+12 "Unscheduled / Walk-In" "Successful"       .25
     -1.8934497e+12 "Unscheduled / Walk-In" "Successful"      1.75
     -1.8934524e+12 "Scheduled"             "Successful"         1
     -1.8934488e+12 "Scheduled"             "Successful"         2
     -1.8934524e+12 "Scheduled"             "Successful"         1
      -1.893456e+12 "Scheduled"             "Successful"         0
     -1.8934506e+12 "Scheduled"             "Successful"       1.5
-1893454500000.0002 "Unscheduled / Walk-In" "Successful"        .4
     -1.8934488e+12 "Scheduled"             "Successful"         2
     -1.8934524e+12 "Scheduled"             "Successful"         1
     -1.8934542e+12 "Unscheduled / Walk-In" "Successful"        .5
     -1.8934542e+12 "Scheduled"             "Successful"        .5
     -1.8934533e+12 "Scheduled"             "Successful"       .75
     -1.8934452e+12 "Unscheduled / Walk-In" "Successful"         3
     -1.8934488e+12 "Scheduled"             "Successful"         2
     -1.8934506e+12 "Scheduled"             "Successful"       1.5
      -1.893456e+12 "Scheduled"             "Successful"         0
     -1.8934533e+12 "Scheduled"             "Successful"       .75
     -1.8934524e+12 "Scheduled"             "Successful"         1
     -1.8934542e+12 "Scheduled"             "Successful"        .5
     -1.8934488e+12 "Unscheduled / Walk-In" "Successful"         2
     -1.8934488e+12 "Scheduled"             "Successful"         2
     -1.8934488e+12 "Scheduled"             "Successful"         2
end
format %tchH:MM client_hrs

        Comment

        Previous Next
        Working...
        X