Solved
Contributor
Posts: 42

# 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

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

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