Recent content by dscheste

You might want to check this one out: http://cben.net/

sdebo - thank you for sharing such a nice code. I was thinking of this approach - just adding a fixed increment to the time given, but I decided against it as this will provoke 2 such incremental calculations for every case I process and there are several hundreds of cases to calculate. I have...

Thank you very much, I will try it. I have already applied some changes to the logic in the formula, however, the formula is presented as a tool to calculate business hours between two time stamps. It might be not a bug as the formula works, just the workflow is flawed. Thank you again for...

Hello, gurus:) I haev been working with Crystal 9 lately because of its incredible job in time calculations and report capabilities. Crystal released a whitepaper on the the formulas, which work with the businesshours. Well, I have used this formula and then tried to check all the records...

No, I did not modify anything. Just changed the values, this is it. No additional comumns. Couple of additional rows, which I re-defined then as the name in excel I was using last time.

This is what I have been using. Cryustal just wants to re-map the field. Why? P.S. The column in the old file contained 1 record, in the updated version the column is empty, but I still need it.

Hello, I have created a report, which involves a great deal of time calculations and is using a lot of different formulae, quering the database. The report seems to work just fine. Now I have to run the report on the renewed data. I have just pasted the values into the old excel file I was...

Hello LBass, thank you for your input. I have this one: And it works just fine substracting the hours and calculating the difference. Anyways, thank you for your help. Last question: I have a CRM with SQL holding the database, what would be your advise as how to link the CRM database and...

bump

Hello Peter Ok. the ticket came in at 12:12, the end of business day is 17:00, than means that the ticket has been worked on for 4:48 (17:00 - 12:12). We have 2 business hours, or 16 business hours for the ticket, so 16 - 4:48 already spent would be 11:12 business hours to go for that ticket...

bump

Hello Peter thank you for constructive criticism, you are partially right. In the prefatory remarks I have mentioned, that I have to add business hours, not business days. So we have to have some variables: 1. Start_of_business_day, (HH:MM:SS) which may very. 2. End of business day...

LBASS - thank you very much for the link to the formula. The site is really interesting. However, the formula does not refer to my problem as it adds or substracts business days. I need hours. 2 busines days = 16 business hours. To illustrate what I am talking about here are some details: Fox...

Hello gurus, hope some of you guys have already run across this one. In Crystal we can easily calculate the amount of business hours between two different dates. There is even a way to work with negative values. I have a problem of another kind. I have to ADD several business hours on a...