Employee Timesheet 1

[Phil00001]

Hi
I,m new to crystal reports, I would very much appreciate help with the following

My report shows following in detail section

Clock On Clock Off
14/05/1012 08:00:00 14/05/1012 13:00:00
14/05/1012 13:30:00 14/05/1012 17:00:00
15/05/1012 08:00:00 15/05/1012 13:00:00
15/05/1012 13:30:00 15/05/1012 17:00:00
16/05/1012 08:00:00 16/05/1012 13:00:00
16/05/1012 13:30:00 16/05/1012 17:00:00
17/05/1012 08:00:00 17/05/1012 13:00:00
17/05/1012 13:30:00 17/05/1012 17:00:00
18/05/1012 08:00:00 18/05/1012 13:00:00
18/05/1012 13:30:00 18/05/1012 17:00:00

I want to end up with the following, by filtering the 13:00:00 and 13:30:00
Clock On Clock Off
14/05/1012 08:00:00 14/05/1012 17:00:00
15/05/1012 08:00:00 15/05/1012 17:00:00
16/05/1012 08:00:00 16/05/1012 17:00:00
17/05/1012 08:00:00 17/05/1012 17:00:00
18/05/1012 08:00:00 18/05/1012 17:00:00

Many Thanks - Phil00001

 

[Madawc]

Group by day. Suppress detail lines. Use Summar totals to show Minimum Clock On and Maximum Clock Off for the day, in the group header or footer. (The use of Crystal's automated totals is outlined at FAQ767-6524.)

If you need hours worked, use DateDiff for each record. Make it a formula field, and it too chan be summarised.

PS. It helps to give your Crystal version - 8, 8.5, 9, 10, 11, 2008 or whatever. Methods sometimes change between versions, and higher versions have extra options. In this case, it probably makes no difference.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP