It can happen that your weight data is shown as e.g.:
606.977.125.538
60.676.106.225
60.674.105.639
606.758.061.371
Some strings are shorter because the last value is a 0. So, dividing all numbers by 10^10 would not give the right outcome all the time.
A BEEP base user has figured out how to change the settings in Excel to get the right numbers:
- Export the data and choose 'comma' or 'pipe' for the values. Weight will be displayd as '61.123456789'
- Select column A and go to Data > Text to colunm > Sperated > Comma > Advanced > Decimal point = .
- Column CA shows the weight as 61,1234
You can use the 'Text to column' function also to split the time-column, thanks to the T in date and time.