Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005

    Unanswered: time difference in crystal report

    I am using Crystal Reports 9.
    I want difference of two times which are stored in two fields.

    for e.g.

    time_in_alloted 09:00
    time_entered 09:45

    now i want to display an additional column which is not present in the database the difference of time which should be
    time_entered - time_in_alloted (result should be 45 minutes).

    Will be thankful for your kind responses.

  2. #2
    Join Date
    Jan 2005
    Avon Lake, OH
    Create a formula:

    DateDiff ("n", {tablename.time_in_alloted}, {tablename.time_entered})

    then drag the formula and drop onto your report.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts