Count formulae

[syedmca]

Hi,

I am beginner in crystal reports I want to calcultate a total timetaken by formtype by suing the formule
total timetaken formtype= count(TOtalformtype)* (max(endtime)-min(starttime))/100 .How can I do this in crystal reports .I mean to say how to write formule for this


Form_ type Tota formtype totaltimetaken
Form_type
HH:MM
AAAA
AAAA
AAAA
AAAA
AAAA 4





BBBBB
BBBBB 2

 

[lbass]

Insert a group on form_type, and then create a formula:

datediff("n",minimum({table.start_time},{table.form_type}),maximum({table.end_time},{table.form_type})

This would return the number of minutes per formtype. Not sure why you would want to multiply that by the count for the formtype or why you would divide by 100.

-LB