Search results for query: *

OK. Nevermind again. Found an article on how to find the average from there: http://support.frontrange.com/support/crystal/making_a_duration_formula.htm lbass : Thank you very much for your help here.

After looking through the Frontrange Crystal Reports: HFW Functions, it looks like they don't have anything like HFWDateToDate for time. They do have HFWDurHoursNormal which would give me what I was looking for originally which is the time elapsed since the opening and closing of the ticket...

Time Fields display like this: After 6pm: 18:03:21

I tried simplifying the formula to see if I could get the report to run at all and I'm still getting the same problem. No errors when saving the formula but it'll give me the "Bad Time Format String" error. I'm using the following formula if isnull({CallLog.ClosedTime}) then Time(0,0,0) else...

Using that formula, I was able to save it, but when I run the report, I get the same error. http://angryhosting-east.mirror.waffleimages.com/files/7a/7a04a3fa449fe4d30815bccc2d2c738caa69d37f.jpg

lbass: I tried this and I got "A date-time is required here."

Ideally, if the closed time is Null, I'd like it to say something like "Ticket Still Open" or the like, but it seems that won't work because it's a string.

I'm trying to create a report that will include the time elapsed since receiving a ticket and it's being closed. The formula I'm using is: DateDiff ("n", DateTime (Hfwdatetodate({CallLog.RecvdDate}),Time({CallLog.RecvdTime})), DateTime...