Are there a family of functions related to "IsDate" which
extract minutes and seconds???

For example:

GetMinutes("22:42") == would return "22"
GetSeconds("13:01") == would return "01"


"Rob van Gelder" wrote in message
...
Use the IsDate function

However, you'll note that ":45" is not considered a valid date.

Sub test()
Debug.Print IsDate("1:22")
Debug.Print IsDate("0:22")
Debug.Print IsDate(":45")
Debug.Print IsDate("6a:20")
Debug.Print IsDate("hello")
End Sub

Cheers,
Rob