Hello, I'm looking for help on Crystal Report programming.

[Former Member]

I’m working on Crystal Report 14.

Here is the formula to count the time between Entrance and Exit:

ToText( Truncate( ({@TimeDiff}) / 60), 0 ) + ":"

      + ToText( Remainder ({@TimeDiff}, 60), "00" )

Here is the formula summarizing multiple Entrances and Exit to give a total per day:

ToText( Truncate( ({#RTotal0}) / 60), 0 ) + ":"

      + ToText( Remainder ({#RTotal0}, 60), "00" )

Employees are grouped by Companies. How can I summarize the time off all employees per Company? I would appreciate any help.

Zbig

[raghavendra_hullur · Accepted solution]

Hi,

Can you explain more on formula content of TimeDiff and Running Total RTotal0?

Is it like you want to summarize entry and exit times separately for each company? If so, insert summaries on entry and exit time database field into group footer for Company or create a formula with sum(<time field>) and convert that to required format for display.

Please provide more info.

Thanks,

Raghavendra

[Former Member · Accepted solution]

Thanks a lot Raghavendra for your helping me,

Here is the RTotal0:

Here is @TimeOff:

I have grouped the workers using Group Expert. The Company field is in Details:

Can you advise what should I enter into the brackets: sum(<time field>), please?

[raghavendra_hullur · Accepted solution]

Hi,

Your timeDiff formula is returning the time difference for each employee.

So, if you want to see the sum of time difference for all employees for each Company, then you have to insert a group on Company if you haven't created one already.

And insert a Summary on your TimeDiff formula field with sum as option for "Calculate this Summary" dropdown.

Select group footer  for group created with Company field under "Summary location" dropdown.

Hope this helps.

Thanks,

Raghavendra