Hi,

I'm quite new to Crystal and would like help on calculating hours worked for instance.

My db has the following:

 
ID    FirstName  LastName  DateTime                DoorName       
6632    John      Doe      30/08/2010 08:07:14    SK TURNSTILE IN       
6632    John      Doe      30/08/2010 12:33:12    SK TURNSTILE OUT       
6632    John      Doe      30/08/2010 13:11:32    SK TURNSTILE IN       
6632    John      Doe      30/08/2010 17:13:41    SK TURNSTILE OUT       
6632    John      Doe      31/08/2010 08:08:15    SK TURNSTILE IN       
6632    John      Doe      31/08/2010 17:25:00    SK TURNSTILE OUT     

How do I calculate last out minus first in?

Thanks

Pieter