Question

Asked on 2007-07-03 at 06:05:44ID: 25187992

Number to time conversion

by: Henry_Wagner50

Rating9.4Excellent

How do I convert a number field that is used to represent start and end of shift times to a friendly non-military time format? The current format is 232637 I'd like to round off the seconds and have it read 11:26 PM. Thanks for any help you can provide.

  1. Field in date time format comparison with today'…
    I know this is simple stuff, but this isn't my ex…
  2. Exporting Txt file format Issues
    I am selecting my export to be TXT format but wh…
  3. Conversions -  String to Number
    I'm in the process of troubleshooting an error th…
  4. Date vs. Date/Time Parameters
    Several of the Date fields in our database are Da…
  5. time conversion
    I have a time stored as the system time (288…

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
time conversion number
Participating Experts
1
Solution Grade
A

Replies

 by: bdreed35

Posted on 2007-07-03 at 06:21:31ID: 26795224

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: Henry_Wagner

Posted on 2007-07-03 at 06:38:45ID: 26795225

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: bdreed35

Posted on 2007-07-03 at 06:52:09ID: 26795226

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: Henry_Wagner

Posted on 2007-07-03 at 07:35:39ID: 26795227

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:

Posted on 2007-07-03 at 07:38:32ID: 26795228

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: Henry_Wagner

Posted on 2007-07-03 at 07:42:58ID: 26795229

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: bdreed35

Posted on 2007-07-03 at 08:23:28ID: 26795230

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?