Alpha Video Training
Results 1 to 4 of 4

Thread: Problem: Decimal time to Standard Time

  1. #1
    Member
    Real Name
    Greg Williams
    Join Date
    Sep 2001
    Posts
    321

    Default Problem: Decimal time to Standard Time

    I have been writing a gateway for a payroll program, and the data is exported from the timeclock in decimal (9.50 rather than 9:30)

    Is there any way to convert these times with a calculated field?

    I broke out the decimal portion with the INT() command, but then when I total all the individual lines for an employee it doesn't recognize that the integer portion should increase after 59 minutes, so I end up with something like this: 77:70.

    HHHEEELLLPPP Please!

  2. #2
    Member
    Real Name
    Stephen Williams
    Join Date
    Apr 2000
    Location
    Oakland, CA
    Posts
    930

    Default RE: Problem: Decimal time to Standard Time

    From my interactive editor
    Decimal_time = 9.50
    Time = alltrim(str(int(Decimal_time)))+":"+alltrim(str(mod(Decimal_time,1)*60))
    ?time
    = "9:30"

  3. #3
    Member
    Real Name
    Greg Williams
    Join Date
    Sep 2001
    Posts
    321

    Default RE: Problem: Decimal time to Standard Time

    Thank you very much!

  4. #4
    "Certified" Alphaholic
    Real Name
    Ken Herrold
    Join Date
    May 2000
    Posts
    1,081

    Default RE: Problem: Decimal time to Standard Time

    BEAUTIFUL STEPHO

    Kenno

Similar Threads

  1. How to convert char time to time value
    By Steven Taylor in forum Alpha Five Version 6
    Replies: 5
    Last Post: 11-19-2004, 09:04 PM
  2. Part time or full time Alpha Develoeprs
    By Henry Rothschild in forum Announcements
    Replies: 5
    Last Post: 06-26-2004, 03:08 PM
  3. Time Problem
    By GregOnline in forum Alpha Five Version 5
    Replies: 1
    Last Post: 06-25-2004, 05:03 PM
  4. Seeking part time or full time Alpha Four and/or A
    By Henry Rothschild in forum Alpha Four Version 6 and Prior
    Replies: 0
    Last Post: 06-18-2004, 01:01 AM
  5. Problem:Decimal Time to Standard Time
    By GregOnline in forum Code Archive
    Replies: 5
    Last Post: 09-10-2001, 04:22 PM

Bookmarks

Posting Permissions

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