![]() Is there a way to simplify this.format the raw hex values with the leading zeros truncated so I can then simply HEX2DEC the truncated values? Notice how leading zeros aren't uniform in length for each attribute? Also if I don't get rid of the ZEROS leading by hand the HEX2DEC returns an error message or displays nothing or a 0 in the cell. Here is the Raw data when it's copied to the clipboard in the next set of linesĠ0000000462DDB26 TotalĜount of Read SectorsĠ000000020F099D0 TotalĜount of Write SectorsĠ000000001392A73 TotalĜount of ReadĜommandsĥ1100 TotalĜount ofĞrror bits from flashĠ0000000000510F2 TotalĜount of Read Sectors withĜorrectableěitĞrrors The HEX values come from Crystal-Mark Info(Gives SMART values for my 128GB (SSD) Solid State Drive) Negative numbers are entered as two's complement. ![]() The most significant bit is the sign bit, the following bits return the value. The number can have a maximum of 10 places. The result is the decimal number for the hexadecimal number entered. Thomasjk wrote:From the help for this formula:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |