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 semi-colons( 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.30-16.30, I'll need to convert it to 15.5-16.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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 205 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!