https://communities.sas.com/t5/SAS-Programming/convert-time-from-minutes-to-hour-and-minutes/m-p/480232#M124095 <P>&nbsp;</P><P>Dear community,</P><P>&nbsp;</P><P>I have data column in minute (column 1) which I want to convert to column 2 (hh:mm).</P><P>and what if the time interval extend beyond 24 hours, what is the best way to present this data?</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P>Column 1</P></TD><TD><P>Column 2</P></TD></TR><TR><TD><P>61</P></TD><TD><P>01:01</P></TD></TR><TR><TD><P>80</P></TD><TD><P>01:20</P></TD></TR><TR><TD><P>50</P></TD><TD><P>00:50</P></TD></TR><TR><TD><P>42</P></TD><TD><P>00:42</P></TD></TR><TR><TD><P>94</P></TD><TD><P>01:34</P></TD></TR><TR><TD><P>49</P></TD><TD><P>00:49</P></TD></TR><TR><TD><P>35</P></TD><TD><P>00:35</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks as always</P><P>zimcom</P> Sun, 22 Jul 2018 13:36:44 GMT zimcom 2018-07-22T13:36:44Z https://communities.sas.com/t5/SAS-Programming/convert-time-from-minutes-to-hour-and-minutes/m-p/480232#M124095 <P>&nbsp;</P><P>Dear community,</P><P>&nbsp;</P><P>I have data column in minute (column 1) which I want to convert to column 2 (hh:mm).</P><P>and what if the time interval extend beyond 24 hours, what is the best way to present this data?</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P>Column 1</P></TD><TD><P>Column 2</P></TD></TR><TR><TD><P>61</P></TD><TD><P>01:01</P></TD></TR><TR><TD><P>80</P></TD><TD><P>01:20</P></TD></TR><TR><TD><P>50</P></TD><TD><P>00:50</P></TD></TR><TR><TD><P>42</P></TD><TD><P>00:42</P></TD></TR><TR><TD><P>94</P></TD><TD><P>01:34</P></TD></TR><TR><TD><P>49</P></TD><TD><P>00:49</P></TD></TR><TR><TD><P>35</P></TD><TD><P>00:35</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks as always</P><P>zimcom</P> Sun, 22 Jul 2018 13:36:44 GMT https://communities.sas.com/t5/SAS-Programming/convert-time-from-minutes-to-hour-and-minutes/m-p/480232#M124095 zimcom 2018-07-22T13:36:44Z https://communities.sas.com/t5/SAS-Programming/convert-time-from-minutes-to-hour-and-minutes/m-p/480235#M124096 Multiply by 60 then you'll have a proper SAS time value, which could just apply a SAS time format (hmm. In your case). Sun, 22 Jul 2018 13:49:20 GMT https://communities.sas.com/t5/SAS-Programming/convert-time-from-minutes-to-hour-and-minutes/m-p/480235#M124096 LinusH 2018-07-22T13:49:20Z https://communities.sas.com/t5/SAS-Programming/convert-time-from-minutes-to-hour-and-minutes/m-p/480237#M124097 <P>column 1 is what I have in my dataset (in minutes) and column 2 is what I want to convert to ...</P> Sun, 22 Jul 2018 14:47:15 GMT https://communities.sas.com/t5/SAS-Programming/convert-time-from-minutes-to-hour-and-minutes/m-p/480237#M124097 zimcom 2018-07-22T14:47:15Z https://communities.sas.com/t5/SAS-Programming/convert-time-from-minutes-to-hour-and-minutes/m-p/480240#M124100 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/219549">@zimcom</a>&nbsp;wrote:<BR /> <P>column 1 is what I have in my dataset (in minutes) and column 2 is what I want to convert to ...</P> <HR /></BLOCKQUOTE> <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/13674">@LinusH</a> has provided the answer, give it a try.</P> Sun, 22 Jul 2018 15:36:25 GMT https://communities.sas.com/t5/SAS-Programming/convert-time-from-minutes-to-hour-and-minutes/m-p/480240#M124100 PaigeMiller 2018-07-22T15:36:25Z https://communities.sas.com/t5/SAS-Programming/convert-time-from-minutes-to-hour-and-minutes/m-p/480241#M124101 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/10892">@PaigeMiller</a><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/13674">@LinusH</a></P><P>Thank you very much!</P> Sun, 22 Jul 2018 15:40:11 GMT https://communities.sas.com/t5/SAS-Programming/convert-time-from-minutes-to-hour-and-minutes/m-p/480241#M124101 zimcom 2018-07-22T15:40:11Z