Hours and Minutes from a DateTime field

[StephenSB]

Hi,

I am trying to get the Hours and minutes elapsed from two datetime fields (both in the format DD/MM/YYYY HH:MM:SS)They both have hours and minutes as well as the date. I have tried using the DateDiff formula but I could only get hours or minutes. Is there any way I can get both?

 

[kenhamady]

If you subtract one date from the other, and convert to total seconds, you can use formula #9 from faq149-243. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com