Print Page | Close Window

How do i calculate Hours from minutes using formul

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1381
Printed Date: 30 Apr 2024 at 2:35am


Topic: How do i calculate Hours from minutes using formul
Posted By: yasinirshad
Subject: How do i calculate Hours from minutes using formul
Date 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.


Replies:
Posted By: Brandtrock
Date 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


Print Page | Close Window