?
Solved

Time difference calculation in crystal reports 7.0

Posted on 2003-02-28
9
Medium Priority
?
4,984 Views
Last Modified: 2009-04-07
hi . i want to calculate time difference between two times in crystal reports 7.0 .. (i know in 8.o onwards crystal gave formula DateDiff(,,)).. i have downloaded u2ldtdif.dll .. but not usefule since i can not able to convert result datetime value into time ...i have time stored in database..
1.  Start time  10:00:00 AM
2.   end time   11:30:00 AM

result should be 1:30 Hrs.

Can anybody help me ..
0
Comment
Question by:amlooks
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
9 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 8041832
You can download the updated date functions from

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/UFLDateAdd.exe.asp

mlmcc
0
 

Author Comment

by:amlooks
ID: 8043991
hi .. i have searched all ufls .. but in vain .. how can i use dateadd to get time difference between two dates .. there is datediff function ..(ufl) .. but it returns in
"xx days xx hours xx minutes xx seconds" which i can not use ...  since my application is of time sheet .. user will enter only time spent during the day .. Now for reporting i have to do it in crystal .. If u can give any example ,, it will be great help ..
0
 
LVL 1

Expert Comment

by:NatashaV
ID: 8044769
Is your start/end time a datetime type or a string?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 101

Expert Comment

by:mlmcc
ID: 8045814
Are you looking for functions to calculate number of hours worked in a day given the start and end times?

What format will the data be in?

mlmcc
0
 

Author Comment

by:amlooks
ID: 8055441
hi .. i am using standard datetime field in access.. i am storing work done from x to y time .. i am storing like
Start work .. 10:00:00 AM (datetiem field)
End Work..     2:30:00 PM  (datetiem field)
so work done is 4:30 Hrs.. like this i have to show total hours in a day & also for each work .. I have downloaded one sample from cyrstal but it is in string format .. not datetime format ..

amit
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 8056935
I'll see if I can develop one.

mlmcc
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 200 total points
ID: 8057587
0
 

Author Comment

by:amlooks
ID: 8063057
Thanks a lot ..
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 8064569
Glad I could help

mlmcc
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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses

762 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