Crystal Reports How to see time diff

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: How to see time diff

Author	Message
harjeet Newbie Joined: 27 Sep 2007 Online Status: Offline Posts: 2	Topic: How to see time diff Posted: 27 Sep 2007 at 8:26am
	verone= 12/09/2007 16:20:00 vertwo= 13/09/2007 01:10:00 how to see the time diff. i used the function Datediff but fail please help
	IP Logged

BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2458	Posted: 27 Sep 2007 at 11:37am
	DateDiff should work. Can you explain why/how it fails? What do you see or not see?
	Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
	IP Logged

harjeet Newbie Joined: 27 Sep 2007 Online Status: Offline Posts: 2	Posted: 29 Sep 2007 at 12:55am
	i used DateDiff ("s",{START_TIME} , {END_TIME})/3600 START_TIME=20 Sep 2007 18:45 END_TIME=21 Sep 2007 03:00 the output i m getting is 08:25 it should be 08:15 thanks jeet
	IP Logged

yggdrasil Senior Member Joined: 19 Jun 2007 Location: United Kingdom Online Status: Offline Posts: 150	Posted: 01 Oct 2007 at 5:32am
	You are getting 8.25 hours, that is eight and a quarter hours, which is right. To get 8 hours and 15 minutes, you wil have to convert the decimal part to minutes
	IP Logged

llopes Newbie Joined: 08 Oct 2007 Location: United States Online Status: Offline Posts: 1	Posted: 08 Oct 2007 at 2:23pm
	Once I have the hours/minutes in decimal form, how then do I convert it to hh:mm?
	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.031 seconds.