时间格式和转换

Question

I have an external XML that provides me this times : 34042, 32406.

34042 should be 147 minutes 32406 should be 120 minutes

Do you have any idea what type of time it is and how can I transform into minutes?

I'm parsing XML with PHP and introduce data in Sql

Answer 1

Using some intuition and trial and error, I solved the logic behind the encrypted time. The two time values you have are in seconds, with an offset of 7 hours (probably because of time zone).

7 hours = 25200 seconds.

Once I subtract the offset from those values, I am left with 8842 and 7206.

Convert those into minutes and the first value becomes 147 minutes and 22 seconds, the second value becomes 120 minutes and 6 seconds. The values of 147 minutes and 120 minutes are just rounded (or floored) values of the time stamp.