convert time from minutes to hour and minutes

[zimcom]

Dear community,

I have data column in minute (column 1) which I want to convert to column 2 (hh:mm).

and what if the time interval extend beyond 24 hours, what is the best way to present this data?

Column 1	Column 2
61	01:01
80	01:20
50	00:50
42	00:42
94	01:34
49	00:49
35	00:35

Thanks as always

zimcom

[LinusH · Accepted solution]

Multiply by 60 then you'll have a proper SAS time value, which could just apply a SAS time format (hmm. In your case).

[zimcom]

column 1 is what I have in my dataset (in minutes) and column 2 is what I want to convert to ...

[PaigeMiller]

---

@zimcom wrote:

column 1 is what I have in my dataset (in minutes) and column 2 is what I want to convert to ...

---

@LinusH has provided the answer, give it a try.

[zimcom]

@PaigeMiller@LinusH

Thank you very much!