Help with creating a duration report in crystal 8.5

[natasha]

Hello Again,

 

Can someone assist me with creating a duration formula for a report i've done in crystal using heat? I see heat has a cduration field and this field is a number. I have been unsuccessful in converting this # to string. I would want the duration time in hh:mm:ss, for calls received to the time it was modified.

 

Any suggestions/assistance you can give me would be greatly appreciated.

 

Many Thanks!

tasha

[natasha]

Hello,

After playing around with this for couple days, I found what i was looking for. Thank You! I guess with time and being able to search around the web it will eventually come. The correct formula i needed to use for my report was

HFWDurHoursNormal({RecvdDate,Time,ModDate,Time}) found on http://www.businessobjects.com/support

 

Kindest Regards,

tasha