Excel VBA Format Textbox Hours and Minutes for Start Time and End Time

Learn how to manipulate textboxes with hours and minutes time formatting. BONUS - at the end, learn how to make it either 24 hour (military time) OR civilian time (am and pm)! Fun stuff!

Fantastic Developer Tools:

[gerardogalavizjimenez]

Excellent! This is exaclty what I was looking for.

[sarahargrave]

This is very helpful. I have an issue though. I want users to be able to enter time as "1:30" and get "1:30 PM" not 1:30 AM. No need for my users to have to know military time to enter the time the call came in. How do I make this happen with the code you provided in the video>

[KnowEverythin]

Sir,
if i text box2 input time is less then input textbox1, then
give error msg in excel... exm textbox1= 00:20, textbox2=23:30... then
give error msg .

[mrsk]

myVar=Empty. Therefore not showing the same value as "Me.tbStart" am pretty much stuck there and cannot go further please assist. Many thanks in advance
Kay

[rezasaberi]

hi dear
In this method, how to diff between start time and end time?

[KnowEverythin]

i have 3 text box, i.e A, B, C. pls provide the formula when i want to output in textbox 3(c} when i want to time difference between textbox1and text box2.
suppose Text box 1 = 22:00(10 pm)
textbox2= 01:00 {1 am)

[krn]

Thanks Daniel. Why did you not have success with FORMAT? Weird stuff happen? I use both TEXT and FORMAT and have not seen much difference yet anyway.

[JanKowalski-hkcg]

Your video is one of the reasons I pay monthly internet fee and buy the apple equipment .. do they share the profit with you?

[grosgros]

hi....where have you declared "myVar"