Hello

 

I want to convert minutes value into an hours and minutes value using a formula in crystal reports however I am not sure how to do this

 

 

Current value (Minutes)        Expected Value (Converted to Hrs and Minutes)

185                                                      = 3.05

55                                                        =0.55

240                                                      = 4.00

238                                                      = 3.58

2                                                          = 0.02

 

 

Regards,

Despina

hi, i was trying to convert min to hour format and the code above if ({@convertm}/60<10 )
then "0"+ totext(({@convertm}/60),0)
else totext(({@convertm}/60),0)

Hi,

 

Thank you for your feedback.  I have been away for a while however I just got back and tried the recommended formula above however when I try to validate it it CR says the remaining test does not appear to be part of the formula (it actually highlights all test)

 

I am new at this and I am not sure what I am doing wrong.  This is what I have put in:

 

xhours=
if int({{Command.WRKD_MINUTES}}/60)<10 then "0"+totext(int({{Command.WRKD_MINUTES}}/60),0)
else totext(int({{Command.WRKD_MINUTES}}/60),0)
 
xminutes=
if {{Command.WRKD_MINUTES}}-((int({{Command.WRKD_MINUTES}}/60))*60)<10 then
    "0"+totext({{Command.WRKD_MINUTES}}-((int({{Command.WRKD_MINUTES}}/60))*60),0)
else
    totext({{Command.WRKD_MINUTES}}-((int({{Command.WRKD_MINUTES}}/60))*60),00)
 
xprintall= {@xhours}+":"+{@xminutes}

 

Appreciate any assistance

 

Regards,
Despina

both of you missed tonumber().

 

 

Global StringVar xhours=

else totext(int(tonumber({Command.WRKD_MINUTES})/60),0)

 

Global StringVar xminutes=

if tonumber({Command.WRKD_MINUTES})-((int(tonumber({Command.WRKD_MINUTES})/60))*60)<10 then

    "0"+totext(tonumber({Command.WRKD_MINUTES})-((int(tonumber({Command.WRKD_MINUTES})/60))*60),0)

else

    totext(tonumber({Command.WRKD_MINUTES})-((int(tonumber({Command.WRKD_MINUTES})/60))*60),00)

 

 

 

hope it help.

 

Edited by Emir_W - 29 Jul 2010 at 8:31pm

Unless you are using 'Basic syntax' (and it does not look like it).  'Crystal Syntax' requires the ':=' for assignment statements.  '=' is for comparisons.