Date/Time Difference in Crystal Reports

I'm creating a report in Crystal Reports XI in which I want to measure the difference (in hours) between two date/time scenarios. One issue is that I'd like to measure business hours only. The other issue is that the dates and times are currently in two different fields. I've used the date difference formula before, but I don't know how to work it for the above issues. Has anyone done this before?
badmanjackAsked:
Who is Participating?
Advertise Here
 
mlmccConnect With a Mentor Commented:
Herre is a formula to calculate the workdays
http://www.kenhamady.com/form01.shtml

Here is a formula for workhours
http://www.kenhamady.com/form13.shtml

mlmcc
0
 
GJParkerCommented:
Will you need to exclude weekends and holidays from the calculation ?
0
 
James0628Commented:
 > The other issue is that the dates and times are currently in two different fields.

 Two different fields (in the same record), or two different _records_?

 Two different fields is the easy one, so I'm guessing that you really meant two different records.  How you handle that may depend on the structure of your data and report.  The simplest thing would probably be if you could change the data so that both datetimes were included in the same record (in two separate fields, of course).  For example, maybe create a view or use a CR command (a query that you create manually) that pulls the two datetimes into one record.

 James
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.