Crystal Reports How do i calculate Hours from minutes using formul

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions

Topic: How do i calculate Hours from minutes using formul

Author	Message
yasinirshad Newbie Joined: 24 Sep 2007 Location: Saudi Arabia Online Status: Offline Posts: 39	Topic: How do i calculate Hours from minutes using formul Posted: 26 Sep 2007 at 3:03am
	Hi, How do i calculate Hours from minutes in Crystal reports. For example: 63 minutes when converting to Hours should give me 1.03 but the below formula gives me 1.05... Formula i used: {iCalls_LeadTime_Report.TOTALMINS}/60 Please let me know. Thanks..
	Thanks, Yasin.
	IP Logged

Brandtrock Newbie Joined: 20 Sep 2007 Online Status: Offline Posts: 2	Posted: 26 Sep 2007 at 12:01pm
	Yasin, 3 minutes is 3/60 or 1/20 of an hour. The correct decimal representation of this is .05 which is what the formula you provided returned for you. Regards,
	Brandtrock
	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.030 seconds.