udg Expert Licensed User Longtime User Oct 12, 2018 #2 Nice. Although in some countries the position of the mark in 565.293 would be read as a decimal separator causing that hour to be read as 0.002
Nice. Although in some countries the position of the mark in 565.293 would be read as a decimal separator causing that hour to be read as 0.002
JordiCP Expert Licensed User Longtime User Oct 12, 2018 #3 udg said: Although in some countries the position of the mark in 565.293 would be read as a decimal separator causing that hour to be read as 0.002 Click to expand... As it would be cheaper for the manufacturer to build only 1 version, a working solution for any country: 1.000 * (565,293 - 565,291 ) (if '.' is thousands separator and ',' is decimal separator --> result = 2 (if '.' is decimal separator and ',' is thousands separator --> result = 2 Enjoyed...
udg said: Although in some countries the position of the mark in 565.293 would be read as a decimal separator causing that hour to be read as 0.002 Click to expand... As it would be cheaper for the manufacturer to build only 1 version, a working solution for any country: 1.000 * (565,293 - 565,291 ) (if '.' is thousands separator and ',' is decimal separator --> result = 2 (if '.' is decimal separator and ',' is thousands separator --> result = 2 Enjoyed...
udg Expert Licensed User Longtime User Oct 12, 2018 #4 1.000 * (565,293 - 565,291 ) Click to expand... Just one word: brilliant
advansis Active Member Licensed User Longtime User Oct 14, 2018 #5 If thousand separator is "," won't the result be 2000?
ilan Expert Licensed User Longtime User Oct 14, 2018 #6 advansis said: If thousand separator is "," won't the result be 2000? Click to expand... No, it would be 2 according to my android calculator Edit: note the the 1.000 has a dot (.) And 565,293 has a comma (,) So it will be or: 1* (2) Or 1000*(0.002) Last edited: Oct 14, 2018
advansis said: If thousand separator is "," won't the result be 2000? Click to expand... No, it would be 2 according to my android calculator Edit: note the the 1.000 has a dot (.) And 565,293 has a comma (,) So it will be or: 1* (2) Or 1000*(0.002)
ilan Expert Licensed User Longtime User Oct 17, 2018 #7 ps, we can tell now that @JordiCP is a very smart person. i would never have thought about that solution.
ps, we can tell now that @JordiCP is a very smart person. i would never have thought about that solution.
JordiCP Expert Licensed User Longtime User Oct 17, 2018 #8 Thanks Ilan, but seriously I do not consider myself specially smart. Just enjoy thinking outside the box in my leisure time, since it is not always (luckily sometimes it is!) 'convenient' in my paid projects Spoiler
Thanks Ilan, but seriously I do not consider myself specially smart. Just enjoy thinking outside the box in my leisure time, since it is not always (luckily sometimes it is!) 'convenient' in my paid projects Spoiler