Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2008
    Posts
    3

    Unanswered:

    I don't know is this a right place for my question but i need help...
    Hi
    I got a database column which has number values like
    480, 495 , 615, 630
    which is equivalent to
    480 = 8am (which is like 480/60=8)
    495 = 8.15am
    615 = 10.00am
    630 = 10.15 am
    i get this values from ctDEdit control, which gives numbers for time.
    Now i have to show this number values as time in crystal reports. so i thought of having a formula field.
    its easy to get hours and minutes from this number:
    its goes like this
    (615/60)=10.25
    so 10 is hours
    (25*60)=1500, here 15 is minutes.
    can any one please help me to do this in a formula field, ie to show the time as 10.15am for number 615.
    i hope im clear.
    thanks

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I don't know the specific CR functions, but the general idea is this:
    Code:
    hours = Floor(615 / 60)
    minutes = 615 Mod 60
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •