<div>
I don't think thats possible, If i look at '11:00' i can't determine if its a 12 or 24 hour format unless it contains an AM or PM notification. <br />
<br />

</div>


I don't think thats possible, If i look at '11:00' i can't determine if its a 12 or 24 hour format unless it contains an AM or PM notification.



<div>
ok, lets assume the existance of AM or PM on the 12H string, and no such indicator on the 24H string..<br />

</div>


ok, lets assume the existance of AM or PM on the 12H string, and no such indicator on the 24H string..


<div>
maybe:<br />
<br />
Function ValidateHour(sHour As String) As Boolean<br />
If InStr(1, sHour, &quot;AM&quot;, vbTextCompare) Or InStr(1, sHour, &quot;PM&quot;, vbTextCompare) Then<br />
&nbsp; &nbsp;ValidateHour = IsDate(sHour)<br />
End If<br />
End Function<br />

</div>


maybe:

Function ValidateHour(sHour As String) As Boolean
If InStr(1, sHour, "AM", vbTextCompare) Or InStr(1, sHour, "PM", vbTextCompare) Then
   ValidateHour = IsDate(sHour)
End If
End Function


<div>
using the isDate() function to test a valid time will work.. &nbsp;doesn't specifically answer the question asked, but the end result for me is the same..<br />

</div>


using the isDate() function to test a valid time will work..  doesn't specifically answer the question asked, but the end result for me is the same..


<div>
Just like Richie posted, If there is PM or AM in time then its a 12 hour notification, otherwise 24. Or am i wrong here ?
</div>


Just like Richie posted, If there is PM or AM in time then its a 12 hour notification, otherwise 24. Or am i wrong here ?

<div>
<div class="content wysiwyg-content">
Hi - I need two visual basic functions, using regular expressions (or a better solution if appropriate?) one to validate that a string is a valid 24H format time value, the other to validate that a string is a valid 12H format time value. &nbsp;Hours and Minutes, no seconds. <br />
<br />
Thanks<br />
-paul<br />

</div>
</div>


Hi - I need two visual basic functions, using regular expressions (or a better solution if appropriate?) one to validate that a string is a valid 24H format time value, the other to validate that a string is a valid 12H format time value.  Hours and Minutes, no seconds. 

Thanks
-paul


Need RegEx to validate time entry

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.