reformatting time field

[Sergeant Ron]

I'm trying to reformat a time field based on the following situation: users enter time in a 24 hour format (2300). The field is formatted to leave as entered. I would however like to have the fields insert current time via script, however obviously when the script runs it would enter this is 11:00:00PM. my question is how can I reformat this time field via calculation to eliminate the separator and the AM/PM. One issue I am having also is that when for instance it is 0700 the hour is one character instead of two which makes the hour part of the calculation either 1 or 2 charcters depending on the time of day. Any help would be greatly appreciated.

Thanks, Ron

[Raybaudi]

users enter time in a 24 hour format (2300).

If the user enters 2300 into a time field you'll have 2300 hours.

Are you entering the time into a text field ?