I have a field that contains a 24 hour clock time as 4 digits. It is a start time. They are number fields (but could be text). Entered simply as #### (ie 1300)

I would like to populate another hidden field with this number converted to a time value of 13:00. Ive tried CAST and CONVERT.

I can do it in Excel with several different formulas but I cant find a Capsio equivalent that doesnt error.

You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

## Question

## roattw

I have a field that contains a 24 hour clock time as 4 digits. It is a start time. They are number fields (but could be text). Entered simply as #### (ie 1300)

I would like to populate another hidden field with this number converted to a time value of 13:00. Ive tried CAST and CONVERT.

I can do it in Excel with several different formulas but I cant find a Capsio equivalent that doesnt error.

=TEXT(field]cell,"0\:00")

Try_Convert(time(0),LEFT([@field:DTN_Start_value],2) +':'+ RIGHT([@field:DTN_Start_value],2))

Any thoughts?

Thanks!

Edited by roattw## Link to comment

## Share on other sites

## 3 answers to this question

## Recommended Posts

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Note:Your post will require moderator approval before it will be visible.