Solved

DateDiff in hh:mi format

Posted on 2011-03-15
1
620 Views
Last Modified: 2012-06-27
How can I get the datediff in my crystal report to display in hh:mi format.  Right now I have,
DateDiff ("n",DateTimeValue ({FinishDateTime}) ,DateTimeValue ({StartDateTime}) )/60

which displays in minutes, but i need to get that converted.

Thanks
0
Comment
Question by:jmpatton
1 Comment
 
LVL 4

Accepted Solution

by:
LeDaouk earned 500 total points
ID: 35138048
hi,
try this link it will solve the problem:
http://www.tek-tips.com/viewthread.cfm?qid=1577627&page=8
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question