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.
Help Article Resources
Check out the Formula Handbook template!