Sum data from certain time ranges

[Former Member]

I am looking to make a calendar and have it setup with a start and end using date and time.  I can use the sum tab to sum up everything for the day during each day.  What I am looking to do is sum up the information for certain time periods. 

ie

7:00:00 am to 02:59:59 pm

03:00:00pm to 10:59:59pm

11:00:00pm to 06:59:59am (This one would be the next day)

Any ideas or suggestions would be helpful.  Currently I have it running a summary from 12am to 11:59:59pm but this does not get me the exact information I need. 

Thanks for any help as I am new to Crystal and still finding my way around.

[Former Member]

Oh and the date time looks like this

7/1/2014   12:00:00AM

[former_member4998]

Hi

To get the required sum data ...create a derived table and with the required logic

and link to the respective table.