Number Field Conversion - Help Please

[keeno]

Hello

I have a Number field (Minutes.Duration) which is showing time in Minutes.

I need to convert this field to Hours.

However when i do that using the formula:

ToText({Minutes.Duration} \ 60, 0, "") & ":" & ToText(Remainder({Minutes.Duration}, 60), 0, "")

It shows the time in Hours (eg 8:42) but the field is now a String field.

However I need it to remain a Number field as i need to use this field in a bar chart.

How can I convert the original Number field (Minutes.Duration) to Hours but it remain a Number field,

I would appreciate any help you can give.

I am using Crystal Reports XI on a Oracle 10G Database

many Thanks

 

[dgillz]

A number cannot contain a colon. Your formula should be:

round({Minutes.Duration}/60,0)+round(Remainder({Minutes.Duration}, 60)/100,2)

This will return a value such as HH.MM where HH is hours and MM is minutes.

If you want to display a colon here, format the field, go to the number tab and select customize, and replace the decimal separator with a colon.

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

http://www.gainfocus.biz

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

 

[keeno]

Thanks for this. This has rounded the field up so 8:42 has become 9.

Is there anyway I can avoid this rounding up and it display the actual number 8.42 as a number

Appreciate your help on this

Thanks

 

[dgillz]

Duh! Silly me for not catching this. Try this formula:

int({Minutes.Duration}/60)+round(Remainder({Minutes.Duration}, 60)/100,2)

Don't forget to format the field as I mentioned and this will return 8:42

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

http://www.gainfocus.biz

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

 

[keeno]

Thanks. However this formula has now rounded down to 8 and is 8:00 when i apply the colon formatting you mention.

Any ideas what i can do to keep the number as 8:42

Many Many Thanks For Your Help

 

[dgillz]

This portion of the formula returns 8:

int({Minutes.Duration}/60)

This portion return 42:

round(Remainder({Minutes.Duration}, 60)/100,2)

Add them together and you get 8.42. format it as I suggested and you get 8:42. Please check your formula.

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

http://www.gainfocus.biz

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