Predicting a future date.

[fragglemoo]

Hi

I am using CR2008 and need some help with a formula to predict a date in the future.

I have a date/time field and need to be able to add 552 hours to this and come up with a future date. Unfortunately this 552 hours is working/business hours only. Mon-Fri 09:00 - 17:30.

Does any one have an idea how I can do this please?

Thanks in advance.

 

[lbass]

Maybe you can work back from Ken Hamady's formula:

http://www.kenhamady.com/form13.shtml

-LB

 

[fragglemoo]

Thanks for the response. The link wasn't what I was looking for but I did find this one on the same site.

http://www.kenhamady.com/form17.shtml