>>

>>cTime = "03:45pm"
>>?HOUR(CTOT("1/1/01 "+cTime))
>>?MINUTE(CTOT("1/1/01 "+cTime))
>>

>
>How does that work? I did work, but it's like magic! Ok, I know it's not magic...

You are just building a DateTime string by adding your time entry to a valid date (1/1/01). Then when you do a CTOT you get a DateTime value which you can pull the HOUR and MINUTE from.

If you are dealing with differnt date formats (other the MDY format) you could try:

cTime = "03:45pm"
?HOUR(CTOT(DTOC(DATE())+" "+cTime))
?MINUTE(CTOT(DTOC(DATE())+" "+cTime))

This makes sure the date format is whatever your date settings are.

Also, I noticed that a TRY...CATCH is not necessary, if the time is an invalid entry, the HOUR and MINUTE return 0