>Thanks Hilmar I have tried it and it works. I also tried to reduce the precision to 5 and 2 mins resp. (the_whole_calc) / (60 *5) I got a 6 digit number. I have tried to decode your original calc and was successful only to the seconds part. I tried reverse calc but my brain gaveway under the strain <g> I this calc reversable?
That's the idea, of course. But when I try it, I see the constants need adjustment - you need to adjust them to the next, not the previous, time conversion unit. Let's try the first part of the calculation.
(Year * 12 + Month) * 24 + Day
Year: 2002.
Month: 11.
Day: 12.
2002 * 12 = 24024
24024 + 11 = 24035
24035 * 24 = 576840
576840 + 12 = 576852
Now, the reverse can be done in several ways, I believe.
576852 / 24 = 24035 (integer part); the remainder (use subtraction, or 576852 % 24) is
12.
24035 / 12 = 2002; the remainder is
11Is it clear now?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)