I have a report which holds detail rows per event date, within each detail row I have two datetime fields which I have then used:-

time(datetime1 - datetime2) to give me the difference in IN and OUT times.

 

The time given is a time field, which I want to sum per group and then by report. If I use the "insert summary" option I get count etc not sum.

 

I've thought about shared timevar but this would need to reset to zero at each change of group and if I do shared timevar:=0   doesnt work, if i use shared timevar:=00:00:00  it asks me to insert )

 

Any idea's....

Many thanks in advance

Sarah

 

However, I've just looked around and noticed that other members have been advised to sum(field,group)/60 - but my group is the event day which in the group sort select I've set to print for each week so if I try this method Crystal responds need the group to match formula

Also noticed that others have used the totext(({table.visitTime}-remainder({table.visitTime},60))/60) + ":" + totext(remainder({table.visitTime},60))  which gives me an answer of ie 945mins becomes 14.00 ; 00.05

 

Thank you for your help in advance.

Yes, the sum of hours worked could amount to more than 24, basically all I require the formula to do is for using the remainder version which totalled the hours worked into minutes correctly, ie 3018. Which I need to equate back 50hrs 18mins...

Sorry