How are you getting the data?
If you are using a stored procedure, I would suggest doing it there, you could use a cursor and loop through each record and apply the logic to an extra hours column, and then in Crystal just see if the column is >= 12 and display the count.
If you are joining to the database directly, you would need to group and order by worker/day and then create a formula that applies your logic to a shared variable. In essence, you are creating your own running total of extra hours in the detail section of the report.
Hope this helps
IP Logged
