Time arithmetic


I am trying to implement a Chart that shows the timings of different batch jobs end time.
So lets say a job ends at 5:35 pm ,the next day the same job ends at 4:22. I’m currently using an epoch time value for that and the curve just keeps growing, since the epoch time is higher and higher, the hour:minute is lower,but the day is higher. I can solve it by reimplementing the code and providing the time after midnight which will be in a range from 0 to 86400 seconds. This second option will work , but i wonder if there is chance to have the same results using the epoch time using some kind of transformation or proper query implementation.Btw, I’m using promql.