Zeroes after decimal point not being extracted
Having issue with decimal numbers. I'm trying to extract the numbers after the decimals, but if it's a whole number, it doesn't recognize the zeroes and just gives the value before the decimal point. Anyone have a solution for this?
The value I want to get out of the above formula is the 00
The reason I need to extract the numbers after the decimal point is because we are putting times with decimal points instead of semicolons( example 15:30 would be 15.30) the problem is for calculations of time I need the value in fractions of hours. For example, if an activity runs between 15.3016.30, I'll need to convert it to 15.516.5 so I can calculate that the activity takes 1 hour to do. If you have another way of converting these time values, that would help me as well.
Answers

Whether it is a number, a date, etc, you need to convert the whatever is in that cell into a string (text) by adding
""
to it before you use the string functions, RIGHT( ), LEFT( ), SUBSTITUTE( ), or MID( ).For example,
RIGHT([Tech 6 End]@row + "", 2)
.Further...
1 + 2
returns3
but1 + "" + 2
returns12
. Thus,RIGHT( 1 + 2, 1)
returns3
andRIGHT( 1 + "" + 2, 1)
returns2
.
Help Article Resources
Categories
Check out the Formula Handbook template!