How to convert number text field to time?

[cecilcheah]

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

 

[jschodde]

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

 

[cecilcheah]

Number with decimals, i need to turn it to time.

EG:

from 8.5 to 8:30

Thanks

Cecil

 

[jschodde]

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

 

[MalcolmW]

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