on 09-23-2014 9:09 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.