×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

How to convert number text field to time?

How to convert number text field to time?

How to convert number text field to time?

(OP)
Hi all:

I am a beginner in CR. I have done a report showing average, maximum and minimun time values for workers coming in to work.

The database i use have all the values as numbers, the report is showing the correct average, max and min number values. Now my problem is i wish to change the text field from number to Time, how can this be done?

I have tried to define three new formula with

CTime (Minimum ({ANAE1OP.ERSTER_ANAESTART}, {ANAE1OP.EO_OPERATIONSSAAL})/60)

But the values returned is not correct.

Am i doing something wrong?

TIA

Cecil Cheah

RE: How to convert number text field to time?

What does the text field's data look like?
-Jeff

RE: How to convert number text field to time?

(OP)
Number with decimals, i need to turn it to time.

EG:

from 8.5 to 8:30

Thanks

Cecil

RE: How to convert number text field to time?

So would 8:35am be 8.583 (35/60 = 0.5833333) ?
What about 8:35pm  - what's it's number format?

I'm just trying to grasp the data patterns.

-Jeff

RE: How to convert number text field to time?

Have you tried putting a seconds value in as well? ie
CTime (Minimum ({ANAE1OP.ERSTER_ANAESTART}, {ANAE1OP.EO_OPERATIONSSAAL})/60,0)

My understanding of this formula is that it requires seconds along with hours and minutes - in V8.5, it generates an error message if the seconds value is missing.

Malcolm

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close