>>
>>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