I need to convert a user-entered number formatted as "1.25" to time as "1:30" for time billing purposes. The entry field is numeric, and my calc field is time using "TextToTime(number_entered)." The result I get only seems to work with values entered as whole numbers (1, 2, 3). When the decimal value is entered the calc field does not display any value, regardless of its length or how it is formatted. Any suggestions?

Thanks,

Mike

>I need to convert a user-entered number formatted as "1.25" to time

>my calc field is time using "TextToTime(number_entered)."

Ummmm. I haven't checked this out, but shouldn't the field containing "1.25" be formatted as a text field since you are converting "Text to Time"? And of course you have the calculation Result is Time.

I tried changing it to a text field, but still get the same result, i.e. only works when whole number are entered.

The strange thing is I know I've gotten this to work before...

Mike

You said that it had been formatted, so I presume you have already gone to Format/Number, and set to at least two decimal digits?

If you're entering your time as hours and decimals hours, why not have it entered into a number field "Number_Input" and then use this calc (time result) to convert it to time format:

Display_Time = Time(Number_Input,0,0)

This will convert 1.25 hours into 1:15:00

If you want to send me an email, I can return a demo with some other handy time calcs in it...

Yes, I have. Thanks all; this calc works:

Display_Time = Time(Number_Input,0,0)

Mike

Thanks Russ. This worked.

Mike