https://communities.sas.com/t5/SAS-Programming/Convert-the-text-time-field-into-time8/m-p/479320#M123694 <P>Time_num = input(time, hhmmss. );</P> <P>fornat time_num time.;</P> Thu, 19 Jul 2018 00:07:26 GMT Reeza 2018-07-19T00:07:26Z https://communities.sas.com/t5/SAS-Programming/Convert-the-text-time-field-into-time8/m-p/479314#M123689 <P>Hi all,</P><P>&nbsp;</P><P>How can I convert the time_1, time_2 and time_3 into time8. format?</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>SUBJECT</TD><TD>time_1</TD><TD>time_2</TD><TD>time_3</TD></TR><TR><TD>117961</TD><TD>18:49</TD><TD>19:02</TD><TD>19:20</TD></TR><TR><TD>118036</TD><TD>15:03</TD><TD>15:35</TD><TD>15:50</TD></TR><TR><TD>118066</TD><TD>19:40</TD><TD>20:10</TD><TD>20:15</TD></TR><TR><TD>118118</TD><TD>0:04</TD><TD>0:25</TD><TD>0:49</TD></TR><TR><TD>118151</TD><TD>23:06</TD><TD>23:30</TD><TD>23:40</TD></TR><TR><TD>118377</TD><TD>9:18</TD><TD>9:39</TD><TD>&nbsp;</TD></TR><TR><TD>118682</TD><TD>14:39</TD><TD>15:06</TD><TD>&nbsp;</TD></TR><TR><TD>118730</TD><TD>12:45</TD><TD>13:04</TD><TD>13:22</TD></TR><TR><TD>118872</TD><TD>18:00</TD><TD>18:23</TD><TD>18:49</TD></TR><TR><TD>118874</TD><TD>16:11</TD><TD>16:18</TD><TD>16:56</TD></TR><TR><TD>118875</TD><TD>15:52</TD><TD>16:15</TD><TD>16:27</TD></TR><TR><TD>119054</TD><TD>23:51</TD><TD>0:06</TD><TD>0:18</TD></TR><TR><TD>119121</TD><TD>15:04</TD><TD>15:15</TD><TD>15:34</TD></TR><TR><TD>119495</TD><TD>11:42</TD><TD>12:13</TD><TD>12:25</TD></TR><TR><TD>119555</TD><TD>13:00</TD><TD>12:59</TD><TD>13:11</TD></TR><TR><TD>119621</TD><TD>18:32</TD><TD>18:48</TD><TD>19:05</TD></TR><TR><TD>119651</TD><TD>8:20</TD><TD>8:41</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Wed, 18 Jul 2018 23:33:03 GMT https://communities.sas.com/t5/SAS-Programming/Convert-the-text-time-field-into-time8/m-p/479314#M123689 zimcom 2018-07-18T23:33:03Z https://communities.sas.com/t5/SAS-Programming/Convert-the-text-time-field-into-time8/m-p/479320#M123694 <P>Time_num = input(time, hhmmss. );</P> <P>fornat time_num time.;</P> Thu, 19 Jul 2018 00:07:26 GMT https://communities.sas.com/t5/SAS-Programming/Convert-the-text-time-field-into-time8/m-p/479320#M123694 Reeza 2018-07-19T00:07:26Z https://communities.sas.com/t5/SAS-Programming/Convert-the-text-time-field-into-time8/m-p/479325#M123698 <P>Thank you, Reeza</P> Thu, 19 Jul 2018 00:28:29 GMT https://communities.sas.com/t5/SAS-Programming/Convert-the-text-time-field-into-time8/m-p/479325#M123698 zimcom 2018-07-19T00:28:29Z