DATA Step, Macro, Functions and more

convert time from minutes to hour and minutes

Accepted Solution Solved
Reply
Contributor
Posts: 42
Accepted Solution

convert time from minutes to hour and minutes

 

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


Accepted Solutions
Solution
a month ago
Super User
Posts: 5,922

Re: convert time from minutes to hour and minutes

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

View solution in original post


All Replies
Solution
a month ago
Super User
Posts: 5,922

Re: convert time from minutes to hour and minutes

Multiply by 60 then you'll have a proper SAS time value, which could just apply a SAS time format (hmm. In your case).
Data never sleeps
Contributor
Posts: 42

Re: convert time from minutes to hour and minutes

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

Respected Advisor
Posts: 3,293

Re: convert time from minutes to hour and minutes


@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.

--
Paige Miller
Contributor
Posts: 42

Re: convert time from minutes to hour and minutes

Posted in reply to PaigeMiller

@PaigeMiller@LinusH

Thank you very much!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 118 views
  • 2 likes
  • 3 in conversation