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
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.