Convert all the values to minutes, add them together, then convert back to hours/minutes. You could write a Crystal formula to do it, but I suspect it's easier in Fox.
>I have a Crystal Report that needs a subtotal and a grand total of a time field. Currently I have 3 fields in the database one is a character field which just shows the time.
>Example 5:30
>I also have two numeric fields which just display just the numbers in the time
>example field 1 shows 5
>example field 2 shows 30
>
>
>If anyone has any ideas on how to do this either through fox pro or crystal.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer