Results 1 to 3 of 3

Thread: sum the hours in crystal

  1. Dec 15th, 2005, 11:35 AM #1
    nilaavu
    nilaavu is offline

    Thread Starter
    Lively Member
    Join Date
    Jul 2005
    Posts
    69

    sum the hours in crystal

    I have a report which displays hours (eg 1:33 ) worked by each employee on a job grouped by date.
    I need to display the total hours on each day. How can I sum the hours in crystal using a formula or some other way possible. I need the total in hours and minutes .
    thx for your help
    Reply With Quote Reply With Quote
  2. Dec 15th, 2005, 02:56 PM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: sum the hours in crystal

    What is the datatype of the Hours field?
    Reply With Quote Reply With Quote
  3. Dec 15th, 2005, 06:00 PM #3
    nilaavu
    nilaavu is offline

    Thread Starter
    Lively Member
    Join Date
    Jul 2005
    Posts
    69

    Re: sum the hours in crystal

    It is a calculated field using datediff of two dates and converting it into the hours:minutes format. In Crystal this field is showing as string.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width