Time Field Calculations - Crystal 8.5 - Help 
Author Message
 Time Field Calculations - Crystal 8.5 - Help

I am new to Crystal Reports but have a simple problem for you experts.
 I have 2 time fields that contain the date AND the time.  For each
record in my Crystal 8.5 report, I need to subtract the StartTime from
the EndTime to get the total minutes.  Then I need to sum this field
up for all the records.

I have looked at the Time and Date Related functions but I cannot seem
to get these to work.  Either it gives me an error on syntax or tells
me "I need to use a date field??"

Here is the layout sorta of the report

Name    Procedure      Number of Prodecures     Minutes(total minutes
of all the procedures, hence starttime and endtime calculations

Any help or better yet sample code would be much appreciated.


Wed, 29 Jun 2005 06:36:01 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Crystal 8.5 crashes when running a report that contain subreports multiple times in a row

2. Crystal Reports 8.5 Parameter Fields

3. Crystal Reports 8.5 date range parameter field - record selection that includes null date range

4. Using Crystal 8.5 and VB6 -- need to get a list of fields available to the report

5. Diary field is truncated when previewing a Crystal Reports 8.5

6. Crystal 8.5 and Dynamic Field Objects

7. Crystal Reports 8.5 Truncates Varchar fields larger then 255 characters

8. Using Crystal Reports 8.5 to Report Fields From Public Contacts Folder on Exchange 5.5 Server

9. SQL Server image fields and Crystal Reports 8.5

10. Crystal 8.5 field hints being displayed

11. SQL Server image fields and Crystal Reports 8.5

12. help:crystal report 8.5 error out date export dll


Powered by phpBB® Forum Software