Print Page | Close Window

Calculate total time on my crystal report

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9397
Printed Date: 08 May 2024 at 12:51pm


Topic: Calculate total time on my crystal report
Posted By: irfi
Subject: Calculate total time on my crystal report
Date Posted: 16 Mar 2010 at 9:57am

Hi everyone,

This is my first post! I am creating crystal report to display attendance record of employees. I am stuck now getting the grand total of (Dailyw
WorkedHrs). Need some help... My desired report output is as follows. I am able to get  the fields "IN1", "IN2" and "TotalHrs" on my report. But need help on getting the "TOTALWORKEDHRS" for each employee which is the sum of "TotalHrs".
 
Any help!!
Cheers
irfi 
 
EmpID 001----------EmpName John Zaq
In1----------Out1----------TotalHrs
09:00-------15:30-------06:30
09:30-------16:00-------07:30
09:15-------17:15-------08:00

TOTALWORKEDHRS 22:00
--------------------------------------------
EmpID 002----------EmpName Sara Bell
In1----------Out1----------TotalHrs
08:00-------15:30-------07:30
08:30-------16:00-------08:30
08:15-------17:15-------09:00

TOTALWORKEDHRS 25:00


Replies:
Posted By: kevlray
Date Posted: 16 Mar 2010 at 11:44am

What data type is TotalHrs?  How did you calculate TotalHrs? 



Print Page | Close Window