Help on Process Time Formula

[ecugrad]

I have two DateTime fields CREATETIME & TERMINATION what I'm trying to do is to subtract the TERMINATION from the CREATETIME to get my processtime from my queue. My problem is that I don't want the time period from 5:00PM to 8:00AM to be included in my calculation.

Example: Createtime 5/14/01 3:00 PM Temination 5/15/01 10:00 AM Total Process Time 19hrs. I would like this to be 4hrs of processing time.

I am using CR8..

Thanks for any help,

Mike

 

[kenhamady]

check out my FAQ on common formulas in the General CR Forum. There is a formula that does this. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)