Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create Elapsed Time Formula 1

Status
Not open for further replies.

KazWaz

MIS
Mar 8, 2001
2
US
I need to create a formula that will report elapsed time between the opening and closing of a help desk ticket. I want to express this in days, hours, minutes, seconds.

TIA . . . Kaz
 
What data type are the fields for opening and closing?

What value do you get if you simply write a formula that is:

Close - Open Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
KazWaz: I have a UFL which does exactly this. You enter 2 datetimes and an optional flag to determine whether you want the text inserted i.e. "hrs" "mins" etc. If you want to try this let me know David C. Monks
david.monks@chase-international.com
Accredited Seagate Enterprise Partner
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top