Create time column for Line chart
So I want to create a line chart that shows the sum of a total over the course of a 24 hour time period.
I have a timestamp column where I extracted the time but tbh it looks weird.
So I was thinking to improve the chart, is to create a column that include all time over a 24 hour period (not military time) and have the metric fall amongst trendline the metric occurred.
Any suggestions? I may be overthinking this.