Try to use DATEPARSE("hhmmss",[Transaction Time]). You should be able to get the result you want by discarding the default year part.
Refer a similar thread Converting an integer to datetime It might be helpful for you
Thank you Manoj for providing solution. Unfortunately, Dateparse function is not available for my case as I'm using live data source. Is there any workaround instead of using dateparse?
Thank you again.