conversion of hrs into mins at script side

[#1]

Hi all,

I want to convert hours into minutes in script side.

EX : I have value 60:90 in that i want to convert 93 as

93 = 93*60 = 55 mins so at the end i want value as  60.55 in script QlikTech Admin

[anbu1984]

How did you get 93? What is 93? Hrs?

[#3]

Hi anbu cheliyan,

Sorry 90 will convert into mins as 90 * 60 = 54  means finally i will get 60:64

[anbu1984]

Load SubField(Val,':',1) & ':' & Ceil(SubField(Val,':',2)*60/100) Inline [

Val

60:90 ];

[#5]

Hi Varde,

It seems you missed something, Send some sample file.

Regards,

Chinni Kanna

[#6]

Hi All,

Please find an attachment

[anbu1984]

Are you converting StandardProcessingTime to HH:MM?