https://community.splunk.com/t5/Getting-Data-In/convert-time-format/m-p/688604#M114669 <P>This run-anywhere example should explain the process.</P><LI-CODE lang="markup">| makeresults | eval STime="9:45" | rex field=STime "(?&lt;hrs&gt;\d+):(?&lt;mins&gt;\d+)" | eval Hours=hrs + round(mins/60,2)</LI-CODE> Fri, 24 May 2024 12:34:17 GMT richgalloway 2024-05-24T12:34:17Z https://community.splunk.com/t5/Getting-Data-In/convert-time-format/m-p/688593#M114667 <P>Hi All,&nbsp;</P><P>I have a splunk query returning output as:</P><P>STime</P><P>09:45</P><P>&nbsp;</P><P>I want to convert it to hours. Expected output:</P><P>STime</P><P>9.75 hrs</P><P>&nbsp;</P><P>How do I achieve this using splunk</P> Fri, 24 May 2024 09:45:27 GMT https://community.splunk.com/t5/Getting-Data-In/convert-time-format/m-p/688593#M114667 avi123 2024-05-24T09:45:27Z https://community.splunk.com/t5/Getting-Data-In/convert-time-format/m-p/688604#M114669 <P>This run-anywhere example should explain the process.</P><LI-CODE lang="markup">| makeresults | eval STime="9:45" | rex field=STime "(?&lt;hrs&gt;\d+):(?&lt;mins&gt;\d+)" | eval Hours=hrs + round(mins/60,2)</LI-CODE> Fri, 24 May 2024 12:34:17 GMT https://community.splunk.com/t5/Getting-Data-In/convert-time-format/m-p/688604#M114669 richgalloway 2024-05-24T12:34:17Z