Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Adding Total Times Post Reply Post New Topic
Author Message
Baratier
Newbie
Newbie


Joined: 13 Apr 2012
Location: Ecuador
Online Status: Offline
Posts: 5
Quote Baratier Replybullet Topic: Adding Total Times
    Posted: 13 Apr 2012 at 10:56am
Hi I am still new with Crystal Reports and I am working on a report that lists all cases performed in a room, and the duration of each case
 
I need to have a summary totaling the number of cases and the total time for all cases. I can't seem to be able to add the times.
 
Data:
Room: OR2
Case  Date            Case duration
123    4/10/2012    1:30
786    4/10/2012    4:15
369    4/11/2012    0:58
 
I need it to sumarize at the end of each room to show:
 
Total OR2:  3 cases performed in 6h43min
 
I got the number of cases but I need help in adding the duration times.
 
Thanks for any tips!
 
Cheers,
B
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 15 Apr 2012 at 2:17pm
You need to convert the durations to minutes, add the minutes, and then use Integer Divide by 60 to get the hours and MOD 60 to get the minutes.
 
-Dell
IP IP Logged
Baratier
Newbie
Newbie


Joined: 13 Apr 2012
Location: Ecuador
Online Status: Offline
Posts: 5
Quote Baratier Replybullet Posted: 19 Apr 2012 at 9:32am
Thanks. IT worked.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.