Crystal Report Formuals

[Guest_imported]

Hello - I have no prior experience with Crystal Reports however - I have to create a report within a week.This is my problem:
I need to create a formula that can continuosly count the number of hours within a 7:00am - 7:00pm work day (12 hours) excluding weekends.How do I do that? Basically, I need the counter to start whenever a case is opened and then continue to count the number of hours until it is closed. The only hours that can be counted are the hours of 7:00am - 7:00pm.

 

[kenhamady]

The following link will show you the formula for calculating work days between two date fields.

http://www.kenhamady.com/form01.html

You will have to:
1) Substitute your date fields in the beginning. If your start and end are datetime fields you will need to change the variable types.
2) Multiply the number of days by the number of hours in a day (12).
3) Adjust (or eliminate) the holiday list depending on if you use holidays and which you use.
4) Finally, you will have to adjust the total based on the Start Time and End time of the first and last day. If you have a date-time field this may happen automatically.

This is a tall order for someone who has no experience with Crystal Formulas. [sig]<p>Ken Hamady<br><a href=mailto:ken@kenhamady.com>ken@kenhamady.com</a><br><a href=

http://www.kenhamady.com/>Crystal

Reports Taining by Ken Hamady</a><br>[/sig]