Crystal 10: Calculate the elapsed time between to dates & times

[pggo08]

Using crystal 10. Trying to create a formula to find elapsed time between

PDMTimeToDateTime ({call_req.open_date})
Example: 11/12/08 3:31 pm

and

PDMTimeToDateTime ({call_req.close_date})
Example: 11/12/08 4:35 pm

Thanks for any Help!!

 

[IanWaterman]

you are really in the wrong forum. Use Business Objects Crystal Reports Formulas.

However, to answer your question use the crystal function datediff

datediff("n", ({call_req.open_date}, ({call_req.close_date})

This will return minutes, using h = hours, s = seconds.

Ian