https://community.splunk.com/t5/Splunk-Search/on-list-of-time-values-how-to-get-start-and-end-times-by/m-p/541506#M153317 <P>&nbsp;</P><LI-CODE lang="markup">| eval date=strftime(_time,"%Y-%m-%d") | stats earliest(_time) as start_time latest(_time) as end_time by date | eval difference=(end_time-start_time)/60</LI-CODE><P>&nbsp;</P> Fri, 26 Feb 2021 12:34:11 GMT ITWhisperer 2021-02-26T12:34:11Z https://community.splunk.com/t5/Splunk-Search/on-list-of-time-values-how-to-get-start-and-end-times-by/m-p/541502#M153316 <P>my search query returns list of _time values for multiple dates and below is start and end times for a each date</P><P><SPAN>2021-02-23 12:27:13.173</SPAN></P><P><SPAN>2021-02-23 16:18:20.129</SPAN></P><P><SPAN>2021-02-24 09:18:06.191</SPAN></P><P><SPAN>2021-02-24 13:22:48.285</SPAN></P><P><SPAN>2021-02-25 09:02:38.042</SPAN></P><P><SPAN>2021-02-25 13:04:52.313</SPAN></P><P><SPAN>in the above list i need to display like below. i have tried multiple ways but unable to get the output in below format. is there any i can extract like below</SPAN></P><TABLE width="389"><TBODY><TR><TD width="68">Date</TD><TD width="89">Start_time</TD><TD width="89">End_time</TD><TD width="143">difference in minutes</TD></TR><TR><TD>2/23/2021</TD><TD>2/23/21 12:27</TD><TD>2/23/21 16:18</TD><TD>231.11593</TD></TR></TBODY></TABLE><P>&nbsp;</P> Fri, 26 Feb 2021 11:57:18 GMT https://community.splunk.com/t5/Splunk-Search/on-list-of-time-values-how-to-get-start-and-end-times-by/m-p/541502#M153316 Sivakesava574 2021-02-26T11:57:18Z https://community.splunk.com/t5/Splunk-Search/on-list-of-time-values-how-to-get-start-and-end-times-by/m-p/541506#M153317 <P>&nbsp;</P><LI-CODE lang="markup">| eval date=strftime(_time,"%Y-%m-%d") | stats earliest(_time) as start_time latest(_time) as end_time by date | eval difference=(end_time-start_time)/60</LI-CODE><P>&nbsp;</P> Fri, 26 Feb 2021 12:34:11 GMT https://community.splunk.com/t5/Splunk-Search/on-list-of-time-values-how-to-get-start-and-end-times-by/m-p/541506#M153317 ITWhisperer 2021-02-26T12:34:11Z https://community.splunk.com/t5/Splunk-Search/on-list-of-time-values-how-to-get-start-and-end-times-by/m-p/541538#M153328 <P>This is resulting the data exactly what i intended</P> Fri, 26 Feb 2021 16:00:23 GMT https://community.splunk.com/t5/Splunk-Search/on-list-of-time-values-how-to-get-start-and-end-times-by/m-p/541538#M153328 Sivakesava574 2021-02-26T16:00:23Z