Hex to Float conversion

Can you please help me with the following,

I am trying to convert a hexadecimal value to a floating number for example 3fa0000000000000 is the hex and its corresponding floating value should be 0.03125. Another example3f847ae147ae147b and the corresponding floating point number is 0.01

Is there any inbuilt formula to achieve the desired result? Any samples?

Developer

Accepted answers

Couldn't find an inbuilt function off the bat and HexToNumber() only seems to work for integers. Was able to set up a Formula Tool to do the calculation (see attached - needs testing). Also added a Python example to do the same.

Found this along the way: https://babbage.cs.qc.cuny.edu/IEEE-754.old/64bit.html

Hope this helps!

Hex to Double Examples.yxmd

Using two's complement.

https://en.wikipedia.org/wiki/Two%27s_complement

Example workflow is attached. Like the case for doubles, will want to test further.

Thanks!

Matt

Hex to Integer Examples.yxmd

Thanks Matt. Appreciate all your help.

All comments

Couldn't find an inbuilt function off the bat and HexToNumber() only seems to work for integers. Was able to set up a Formula Tool to do the calculation (see attached - needs testing). Also added a Python example to do the same.

Found this along the way: https://babbage.cs.qc.cuny.edu/IEEE-754.old/64bit.html

Hope this helps!

Hex to Double Examples.yxmd

Thanks it works. Appreciate your help.

Thats great!

If you don’t mind marking as the solution, that would be a big help!

Thanks!

Maty

Quick Links

Tags

This months top contributors

AkimasaKajitani 387

Hollingsworth 335