I'm using Ken Hanady's formula to calculate business hours and it gives me the correct results if a ticket has been opened and closed during business hours of 8:00 - 16:00. I've got tickets that are opened and closed outside of these hours and get a negative number. His business hours formula states: "You will get unpredicatble results if you have records that start and end 'after hours'. These records need to be adjusted in a separate formula before they are run through this formula." What's the formula to adjust these records? I'm using Crystal 8.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Calculate Start and End Time if outside of business hours.
- Thread starter jtd353
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question