OK.
For some reason my brain has not quite gotten back to work from a long weekend
but here is the premise of a solution...
At the grouping of field "4489", set a summary function of the time stamp field to Minimum (basically activate the datetimefield, cilck on the sigma sign button, set it to 'Minimum' and location group footer1).
Now you can use that in a formula field per row to do a datediff to get the total seconds of difference then alter that to display as the h:m:s formatting you want. Thi sis where my brain is frozen up as I cannot think how to get the hours to work right without rounding up...maybe you can tweak this or someone else will fix it...It will be something like:
totext(datediff("s",Minimum ({Table.DateTime}, Group1Field, "daily"),{Table.DateTime})/3600,0,"") + ":" +
totext(remainder(datediff("s",Minimum ({Table.DateTime}, group1 field, "daily"),{Table.DateTime}),3600)/60,0,"") + ":" +
totext(remainder(datediff("s",Minimum ({Table.DateTime}, group1Field, "daily"),{Table.DateTime}),60))
IP Logged
