SPL
Convert Seconds to Hours Minutes Seconds HHMMSS
Description
Take any field in splunk that outputs a value in seconds and change it to report in HH:MM:SS format:
9 0
your.search.here | eval HHMMSS=tostring(Field_In_Seconds, "duration") | table HHMMSS
Comments
1 total
2 Hours 0 Minutes 04 Seconds \r\n2 Hours 0 Minutes 08 Seconds \r\n2 Hours 0 Minutes 12 Seconds \r\n2 Hours 0 Minutes 16 Seconds \r\n2 Hours 0 Minutes 20 Seconds \r\n2 Hours 0 Minutes 24 Seconds \r\n2 Hours 0 Minutes 28 Seconds \r\n2 Hours 0 Minutes 32 Seconds \r\n2 Hours 0 Minutes 36 Seconds \r\n2 Hours 0 Minutes 40 Seconds \r\n2 Hours 0 Minutes 44 Seconds \r\n2 Hours 0 Minutes 48 Seconds \r\n2 Hours 0 Minutes 52 Seconds \r\n2 Hours 0 Minutes 56 Seconds \r\n2 Hours 0 Minutes 60 Seconds \r\n2 Hours 0 Minutes 64 Seconds \r\n2 Hours 0 Minutes 68 Seconds \r\n2 Hours 0 Minutes 72 Seconds \r\n2 Hours 0 Minutes 76 Seconds \r\n2 Hours 0 Minutes 80 Seconds \r\n2 Hours 0 Minutes 84 Seconds \r\n2 Hours 0 Minutes 88 Seconds \r\n2 Hours 0 Minutes 92 Seconds \r\n2 Hours 0 Minutes 96 Seconds \r\n2 Hours 1 Minutes 00 Seconds
Leave a comment
You must log in to post a comment.