Formulae for total form processed per hour

[syedmca]

How do I need to create a formula in Crystal Reports (CR) to get the TotForm HR
Calculation to be performed is Totformhr= total processed*3600/timetaken

Kindly help me by guiding steps need to be taken to get this formula in crystal reports.How many variables need to be created.How to do calc

Form_type TotalProcessed Timetaken TotForm HR
HH:MM:SS
AAAA 15 0:00:46 1173.91
BBBB 1 0:00:12 300.00
CCCC 169 0:18:26 550.09
--------------------------------------------------
185 0:19:24 572.16


Thanks in advance
Syed

 

[raja2008]

Hello Syed !

are you trying to convert the timetaken into seconds.
In that case:
There are Hour and Minute and second functions that will extract the hour and minutes from the time then you can * by 60 and get the timetaken in seconds.

totalprocessedfield*(3600/((hour(timetaken)*60)+ (minute(timetaken)*60) + second(timetaken)))

Hope i got you right and this helps.

 

[lbass]

I think what you want is:

({table.totalprocessed}*3600)/(hour({table.timetaken})*3600 + minute({table.timetaken})* 60 + second({table.timetaken}))

...assuming timetaken is in fact a time and not a string.

-LB