Question

Asked on 2003-03-11 at 03:54:23ID: 25189831

Require Crystal to convert a number into a time format

by: Littleone50

Rating7.4Very Good

I have a field within my database which holds a number.  This number represents a time value in minutes.  This number of minutes value needs converting into a hh:mm time format.  So the number field (actually holds the time in minutes)

So for example the number field would contain 105 and Crystal reports needs to display this as 1hr 45mins (or something similarly equivalent which users can equate to).

Please can anybody advise me on how to do this.



  1. Field in date time format comparison with today'…
    I know this is simple stuff, but this isn't my ex…
  2. Date vs. Date/Time Parameters
    Several of the Date fields in our database are Da…
  3. time conversion
    I have a time stored as the system time (288…
  4. Establishing January 1st in a formula.
    Hello, I'm working on a few financial repor…
  5. Showing latest transaction date of an item based …
    Hello, I have difficulties in returning the l…

Solution

Access this solution immediately by signing up as a member of CrystalReportsExperts.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.

About this Solution

Sign up Now to View This Solution
Zone
general
Tags
Participating Experts
5
Solution Grade
A

Replies

 by:

Posted on 2003-03-11 at 06:13:03ID: 26805589

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: mlmcc

Posted on 2003-03-11 at 07:11:43ID: 26805590

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: ShaggDog

Posted on 2003-03-11 at 09:14:29ID: 26805591

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: TheLearnedOne

Posted on 2004-08-13 at 11:50:08ID: 26805592

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: modulo

Posted on 2004-08-18 at 01:28:04ID: 26805593

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Log In

Forgot your password?Sign up

Stay Connected

Top Experts

  1. mlmcc

    334,774

    Wizard

    0 points yesterday

    Profile
  2. James0628

    70,696

    Master

    0 points yesterday

    Profile
  3. LinInDenver

    4,800

    0 points yesterday

    Profile
  4. peter57r

    4,000

    0 points yesterday

    Profile
  5. 13598

    3,520

    0 points yesterday

    Profile
  6. PCIIain

    1,700

    0 points yesterday

    Profile
  7. RickIsWright

    400

    0 points yesterday

    Profile
  8. Dan3D

    300

    0 points yesterday

    Profile

BrowseAre you an Expert?