Print Page | Close Window

How to get average of seconds in hours:min:sec

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=6394
Printed Date: 17 May 2024 at 7:35pm


Topic: How to get average of seconds in hours:min:sec
Posted By: rajeshnsn
Subject: How to get average of seconds in hours:min:sec
Date Posted: 19 May 2009 at 2:35am
Hi gyes,
 
Using formula datediff() i am getting date difference of two date fields in seconds format.
 
then using summary option i am taking the average of the field.
 
But the output is in Seconds format like 5000...  but i want in DAys , hours, min,sec format.....
 
 
How to procced?.
 
 
 
 


-------------
rajesh


Print Page | Close Window