Remove a decimal E.g. 0.56 = 56

[ajstickland]

Hi

I have been looking all over Cyrstal help and internet to find the solution to this problem:

I need to remove decimals from the value in a variable so that I can use the below code to convert minutes into hours:

If HourRem <> 00 then 1/(60/HourRem);

For example 0.30 = 1/(60/HourRem = 30) = 0.5.

I know in SqlServer this function is called Convert.ToDecimal if that is of any help? I have also looked at the date and time functions and these do not help either.

Has anyone got any ideas?

Thanks for your help.

 

[dgillz]

Are you saying you want your example to return 50 instead of .5? Multiply by 100.

There is no function to do this that I am aware of. It is awfully easy to multiply by 100 so I doubt that anyone would create such a function.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?